RE: [GENERAL] too many clients

2001-06-08 Thread Nicolas Huillard
Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe different for 7.x) NH -Message d'origine- De: jochen mader [SMTP:[EMAIL PROTECTED]] Date: vendredi 8 juin 2001 13:53 À:[EMAIL PROTECTED] Objet:[GENERAL] too many clients First: Thanks to

Re: [GENERAL] Writing transactions in plpgsql

2001-06-08 Thread Allan Kamau
I would like to write begin and commit/rollback transaction instructions in plpgsql functions I am writing. Also how to write 'lock serializable' in plpgsql Thank you in advance. Allan Kamau. __ Do You Yahoo!? Get personalized email

RE: [GENERAL] too many clients

2001-06-08 Thread Christian Bucanac
Hi! Use the -N flag to set number of client connections when starting postmaster. See manual page for postmaster. /Buckis -Original Message- From: jochen mader [mailto:[EMAIL PROTECTED]] Sent: den 8 juni 2001 13:53 To: [EMAIL PROTECTED] Subject: [GENERAL] too many clients First:

[GENERAL] 7.1 upgrade problems

2001-06-08 Thread Andreas Tille
Hello, I just updated a smaller database with some functions declared LANGUAGE 'plpgsql'; from 7.0.3 to 7.1 (Debian package 7.1release-4) The Debian package of postgresql 7.1 replaces the former extra package postgresql-pl and so I guess that plpgsql support is now included in the

Re: [GENERAL] Writing transactions in plpgsql

2001-06-08 Thread Allan Kamau
I would like to write begin and commit/rollback transaction instructions within plpgsql writen functions. Also how to write 'lock serializable' in plpgsql. Thank you in advance. Allan Kamau. __ Do You Yahoo!? Get personalized email

Re: [GENERAL] 7.1 upgrade problems

2001-06-08 Thread Michael Meskes
On Fri, Jun 08, 2001 at 04:37:42PM +0200, Andreas Tille wrote: The Debian package of postgresql 7.1 replaces the former extra package postgresql-pl and so I guess that plpgsql support is now included in the postgresql package. Unfortunately I get It is. ERROR: Unrecognized language

[GENERAL] Where is libpq-fe.h?

2001-06-08 Thread Barry Jeapes
Im trying to install DBD-Pg so that I can connect to pgsql databases through Perl. The README files say I should set some environment variables.. quoting the readme file: ...The Makefile checks the environment variables POSTGRES_INCLUDE and POSTGRES_LIB, to find the library libpq.so and the

Re: [GENERAL] Should Cygwin PostgreSQL contain all header files?

2001-06-08 Thread Tom Lane
Jason Tishler [EMAIL PROTECTED] writes: The bottom line is should I be using make -C src/include install-all-headers instead of make -C src/include install or is PoPy's use of non-client-side headers incorrect? If PoPy is client-side code and not something that loads into the

Re: [GENERAL] too many clients

2001-06-08 Thread jochen mader
On Friday 08 June 2001 16:45, you wrote: Look at the -N (and -B) options of the postmaster process (for 6.5.3, maybe different for 7.x) Thanks a lot, overlooked this one :-) ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ?

Re: [GENERAL] Should Cygwin PostgreSQL contain all header files?

2001-06-08 Thread Jason Tishler
Tom, On Fri, Jun 08, 2001 at 12:40:47PM -0400, Tom Lane wrote: Jason Tishler [EMAIL PROTECTED] writes: The bottom line is should I be using make -C src/include install-all-headers instead of make -C src/include install or is PoPy's use of non-client-side headers incorrect?

Re: [GENERAL] Slow droping tables

2001-06-08 Thread Tom Lane
Somazx Interesting [EMAIL PROTECTED] writes: Can anyone think of anything that would cause dropping a table with little data contained within it to take several seconds (and growing)? Can't see a reason for that offhand. - upgraded to 7.1 but not to 7.1.2 I'd strongly recommend moving to

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Tom Lane
Somazx Interesting [EMAIL PROTECTED] writes: getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exiting Kinda looks like you dropped some function that was still referenced by a trigger. Better drop the trigger too.

Re: [GENERAL] inserting, index and no index - speed

2001-06-08 Thread Tom Lane
[EMAIL PROTECTED] writes: I just noticed that inserting 1 tuples in an indexed table took exactly the same amount of time as inserting 1 tuples in a non-indexed table (194 seconds). Why is this? The difference in MySQL is about 50% longer in an indexed table. Surprises me too. Which

[GENERAL] error starting postmaster

2001-06-08 Thread Peter Choe
i just installed postgresql7.1 on a freebsd 4.3-stable machine. and i am able to start it with: postmaster -D data but when i try to: createdb test i get the following error: /usr/libexec/ld-elf.so.1: Shared object libpq.so.2 not found where can i get libpq.so.2? peter choe

Re: [GENERAL] A join that should be very fast is taking a long time

2001-06-08 Thread Tom Lane
Nick Ganju [EMAIL PROTECTED] writes: I am trying to do the following query: select * from track_category_track c, track_datafile d where c.track_id='49682224EB2753AB0A262ACB00172E08' and d.track_id=c.track_id This takes more than 1 second to run, even though track_id is indexed in both

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Somazx Interesting
At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: Somazx Interesting [EMAIL PROTECTED] writes: getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exiting Kinda looks like you dropped some function that was still referenced by a

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Stephan Szabo
On Fri, 8 Jun 2001, Somazx Interesting wrote: At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: Somazx Interesting [EMAIL PROTECTED] writes: getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exiting Kinda looks like you

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Tom Lane
Somazx Interesting [EMAIL PROTECTED] writes: Taking that to mean, try deleting that orphaned trigger - but since I don't know which table that trigger was on - I did it by deleting it through pg_trigger, I now get somewhat worse errors: getTables(): relation 'lessontable_548_118': 8

[GENERAL] Cleanly cancel a query.

2001-06-08 Thread Dennis
If I have a database running, and I see that there is a postmaster process taking 99.9% cpu. ie, a very large insert query. Is there a way to cleanly shut down that query from the client or admin side? -Thanks ---(end of broadcast)--- TIP 4:

Re: [GENERAL] Can not pg_dumpall

2001-06-08 Thread Somazx Interesting
At 01:30 PM 6/8/2001 -0700, you wrote: At 02:18 PM 6/8/2001 -0400, Tom Lane wrote: Somazx Interesting [EMAIL PROTECTED] writes: getTables(): SELECT (funcname) for trigger sa_eval_trigger_608 returned 0 tuples. Expected 1. pg_dump failed on OnEd, exiting This is easy to fix,

Re: [GENERAL] Cleanly cancel a query.

2001-06-08 Thread Thalis A. Kalfigopoulos
You can kill -TERM the postmaster that is executing the particular query. cheers, t. On Fri, 8 Jun 2001, Dennis wrote: If I have a database running, and I see that there is a postmaster process taking 99.9% cpu. ie, a very large insert query. Is there a way to cleanly shut down that

Re: [GENERAL] Cleanly cancel a query.

2001-06-08 Thread Thalis A. Kalfigopoulos
To be more precise, if by a very large insert you mean an import of a large data file via COPY, then it is fully transactional i.e. if you kill -TERM the corresponding postmaster, it'll be like the insert never took place. If you mean multiple INSERTs in a transaction block then again the same.

[GENERAL] Re: error starting postmaster

2001-06-08 Thread Vivek Khera
PC == Peter Choe [EMAIL PROTECTED] writes: PC i just installed postgresql7.1 on a freebsd 4.3-stable machine. and i PC am able to start it with: PC postmaster -D data PC but when i try to: PC createdb test PC i get the following error: PC /usr/libexec/ld-elf.so.1: Shared object libpq.so.2

[GENERAL] Elephant Book - Removed Software

2001-06-08 Thread pgsql-general
Hello, We have decided that we will not be including GreatBridge PostgreSQL and instead will be focussing on the community released version. As always updated information on the book can be found on the web at: http://www.opendocspublishing.com/entry.lxp?lxpe=92 Joshua Drake

[GENERAL] Re: very big problem with NULL

2001-06-08 Thread Vivek Khera
g == grant [EMAIL PROTECTED] writes: g However, the last time i checked, NULL does not equal to 1, 2, 3, g or anything else besides NULL. Thats why I'm confused as to why g SELECT column FROM table WHERE column != 1 also excludes NULL, g because 1 does NOT have the same value as NULL. Ok,