Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Neil Conway
Martin Pitt said: > If you just output a rollback command on exit, then it is already too > late to rescue the pending transaction, so I'm not sure whether that > would help this use case so much. Well, the DBA can always replay the transaction manually -- I think notifying the DBA that their modi

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Martin Pitt
Hi, Neil Conway [2007-09-17 10:16 -0700]: > At a minimum, I think we could make the fact that the transaction > has been rolled back more obvious (e.g. echo a ROLLBACK command tag > to the output or a similar warning message). Asking for confirmation > might be too chatty, and it's certainly not p

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > At a minimum, I think we could make the fact that the transaction > has been rolled back more obvious (e.g. echo a ROLLBACK command tag > to the output or a similar warning message). Asking for confirmation > might be too chatty, and it's certainly not poss

[BUGS] BUG #3615: Exception with loading string value

2007-09-17 Thread Sundarrajan
The following bug has been logged online: Bug reference: 3615 Logged by: Sundarrajan Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.3 Operating system: Windows Description:Exception with loading string value Details: I am trying to load table data using hi

Re: [BUGS] autovacuum starting for no apparent reason

2007-09-17 Thread Stefan Kaltenbrunner
hubert depesz lubaczewski wrote: > 1. postgresql 8.2.4 > 2. system is 8-way xeon, 64bit with 32gram. > 3. autovacuum is (and was) turned off in configuration. > 4. today in peak hours autovacuum started. no mention of it in logs. it > just showed. started to vacuum the largest table in main databas

Re: [BUGS] autovacuum starting for no apparent reason

2007-09-17 Thread hubert depesz lubaczewski
sorry to bother you. problem has been found, it's the (default, too low) value of autovacuum_freeze_max_age. depesz -- quicksil1er: "postgres is excellent, but like any DB it requires a highly paid DBA. here's my CV!" :) http://www.depesz.com/ - blog dla ciebie (i moje CV)

[BUGS] autovacuum starting for no apparent reason

2007-09-17 Thread hubert depesz lubaczewski
1. postgresql 8.2.4 2. system is 8-way xeon, 64bit with 32gram. 3. autovacuum is (and was) turned off in configuration. 4. today in peak hours autovacuum started. no mention of it in logs. it just showed. started to vacuum the largest table in main database, and brought the website down due to enor

Re: [BUGS] psql CLI: warn about ongoing transaction on exit

2007-09-17 Thread Neil Conway
On Sun, 2007-09-16 at 20:34 +0200, Martin Pitt wrote: > users=> begin; > BEGIN > [...] > users=> \q > $ ... > > It would be really nice if psql prompted me whether I wanted to do > this. As it stands, it just rolls back the transaction." At a minimum, I think we could make the fact that the trans

[BUGS] BUG #3614: pg_config returns incorrect information for includedir-server

2007-09-17 Thread Michael Akinde
The following bug has been logged online: Bug reference: 3614 Logged by: Michael Akinde Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: linux/Fedora Core 5 Description:pg_config returns incorrect information for includedir-server Details:

[BUGS] BUG #3613: Numeric type problem

2007-09-17 Thread jack
The following bug has been logged online: Bug reference: 3613 Logged by: jack Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.4 Operating system: winxp Description:Numeric type problem Details: Hi All, I met a numeric type problem,detail : 1.Programe lan