Re: [GENERAL] Slow network retrieves

2004-05-12 Thread wespvp
On 5/9/04 1:58 PM, Tom Lane [EMAIL PROTECTED] wrote: I am not sure how either of these techniques map into ecpg though. If you want to use ecpg then I'd suggest bringing up the question on pgsql-interfaces --- the ecpg gurus are more likely to be paying attention over there. I got some

Re: [GENERAL] Is Linux 2.6.5 kernel good enough for production?

2004-05-12 Thread Dirk Försterling
Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes: Do people think linux 2.6.5 is stable enough yet for a production PostgreSQL server? i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux version 10) I'd like to add here, that I recently tried 2.6.5 / Postgres

Re: [GENERAL] Data Encryption in PostgreSQL, and a Tutorial.

2004-05-12 Thread Dias Bantekas
[EMAIL PROTECTED] wrote: Dias Bantekas wrote: does any one know how to get an md5()-like hash function using pgcrypto for postgresql 7.3 ? without upgrading to 7.4 Thanks for any input. SELECT encode(digest(v_password, 'md5'), 'hex'); BTW, /usr/share/pgsql/contrib/pgcrypto.sql is the script

[GENERAL] query progress indicator

2004-05-12 Thread David Garamond
[= ] 56% ETA ... I know there is no such thing in Postgres right now (though there is pg_stat_activity). But is there database product that can do this? -- dave ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [GENERAL] Need a hardware optimization pointer

2004-05-12 Thread Shridhar Daithankar
Daniel Fitzgerald wrote: Hi all, I need some pointers. I want to optimize my pgsql databases hardware-wise. I can do this in Sybase, Oracle, SQL Server, etc. by putting let's say, indexes on one device, the trasaction logs on another, data on another drive, etc. Can I do this in Postgresql ? I

Re: [GENERAL] query progress indicator

2004-05-12 Thread Kris Jurka
On Mon, 9 Feb 2004, David Garamond wrote: [= ] 56% ETA ... I know there is no such thing in Postgres right now (though there is pg_stat_activity). But is there database product that can do this? When pg is processing a query it doesn't know how long it will take,

Re: [GENERAL] disallowing multiple NULLs in a unique constraint

2004-05-12 Thread Peter Eisentraut
Am Montag, 9. Februar 2004 06:06 schrieb David Garamond: SQL Server only allow one NULL in a unique constraint column (it's the unique index that does that, so the unique constraint behaves like that too). The question is, what is the best way to simulate that behaviour in Postgres? Can a

[GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Sorry if this has already been covered... Suddenly I'm receiving every post to the pgsql-general list twice; been happening for a couple days now. I even unsubscribed for a bit and then resubscribed, but it continues. Is this just me, or is this a global thing? FWIW, I'm only getting single

Re: [GENERAL] vacuumdb is failing with NUMBER OF INDEX TUPLES NOT

2004-05-12 Thread Andrew Sullivan
On Mon, May 10, 2004 at 07:49:42PM -0400, Tom Lane wrote: Hmm, I would expect that behavior for an overwrite-in-place REINDEX, but 7.2 only seems to use overwrite-in-place for critical system catalogs. What were you reindexing exactly? Were you running a standalone backend? Not as far as

Re: [GENERAL] Cache lookup failure for pg_restore?

2004-05-12 Thread Gellert, Andre
Hello, Recently, we discover how to avoid problem with OIDs backup/restore in tsearch2. Check http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ for a little patch (regprocedure_7.4.patch.gz). It won't work on existed tsearch2 installation, though, but will help in future. I do

Re: [GENERAL] Is Linux 2.6.5 kernel good enough for production?

2004-05-12 Thread scott.marlowe
On Wed, 12 May 2004, Dirk Försterling wrote: Am 05/05/2004 03:03 PM schrieb Luiz Rafael Culik Guimaraes: Do people think linux 2.6.5 is stable enough yet for a production PostgreSQL server? i´m using linux 2.6.5 with postgres 7.4.2 with out problem(conectiva linux version 10) I'd

Re: [GENERAL] disallowing multiple NULLs in a unique constraint

2004-05-12 Thread scott.marlowe
On Wed, 12 May 2004, Peter Eisentraut wrote: Am Montag, 9. Februar 2004 06:06 schrieb David Garamond: SQL Server only allow one NULL in a unique constraint column (it's the unique index that does that, so the unique constraint behaves like that too). The question is, what is the best way

Re: [GENERAL] Cache lookup failure for pg_restore?

2004-05-12 Thread Oleg Bartunov
Hi, Below is a email from Andrew Kopciuch who tested the patch and wrote some instruction. sql file is available from http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/regprocedure_update.sql Andrew, could you help Andre with his problem ? Oleg

Re: [GENERAL] OT: Dup mails

2004-05-12 Thread Andrew Kelly
Whoops, disregard please. I shoulda noticed that the headers were identical before I went whining to the list. Sorry everybody. Turns out to have been a hammered chain of filters. Thanks for the nudge, Tom. Andy On Wed, 2004-05-12 at 13:03, Andrew Kelly wrote: Sorry if this has already been

Re: [GENERAL] LISTEN/NOTIFY with JDBC

2004-05-12 Thread Glenn Sullivan
Kris, Thanks for the response. I have been using Sun's JDBC. Do I take it that I need to create and use the Postgres JDBC to get the ability to do NOTIFY/LISTEN? Glenn Kris Jurka wrote: On Tue, 11 May 2004, Glenn Sullivan wrote: Hi, I have been trying to get LISTEN/NOTIFY working in with