Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Alvaro Herrera
Tom Lane escribió: Alvaro Herrera [EMAIL PROTECTED] writes: I don't advocate changing that ERROR to anything else. The message wording, as Tom says, can easily be changed -- I think this patch should be enough. Feel free to propose better wording. Minor gripe: all three variants of the

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Simon Riggs
On Thu, 2007-12-06 at 11:33 -0300, Alvaro Herrera wrote: Tom Lane escribió: Alvaro Herrera [EMAIL PROTECTED] writes: I don't advocate changing that ERROR to anything else. The message wording, as Tom says, can easily be changed -- I think this patch should be enough. Feel free to

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Alvaro Herrera
Simon Riggs escribió: Sorry to come in on late on this: That wording is better, but it still doesn't explain why it has occurred or what the user should do about it. I think we will get other complaints saying why has my autovacuum been canceled? and what should I do about this?. Perhaps

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Simon Riggs
On Thu, 2007-12-06 at 12:03 -0300, Alvaro Herrera wrote: Simon Riggs escribió: Sorry to come in on late on this: That wording is better, but it still doesn't explain why it has occurred or what the user should do about it. I think we will get other complaints saying why has my autovacuum

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: True. We can say task will be automatically re-scheduled, so that people understand the message and don't start asking us. How about temporarily canceling autovacuum task? This is accurate regardless of the origin of the SIGINT.

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Alvaro Herrera
Tom Lane escribió: Simon Riggs [EMAIL PROTECTED] writes: True. We can say task will be automatically re-scheduled, so that people understand the message and don't start asking us. How about temporarily canceling autovacuum task? This is accurate regardless of the origin of the SIGINT.

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-06 Thread Simon Riggs
On Thu, 2007-12-06 at 12:24 -0300, Alvaro Herrera wrote: Tom Lane escribió: Simon Riggs [EMAIL PROTECTED] writes: True. We can say task will be automatically re-scheduled, so that people understand the message and don't start asking us. How about temporarily canceling autovacuum

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-04 Thread Tom Lane
Gregory Stark [EMAIL PROTECTED] writes: I guess we should capture this error with a PG_TRY and silently abort instead. Just a NOTICE or INFO should be sufficient. Other errors should of course be rethrown. This falls in the category of destabilizing the code for purely cosmetic reasons, and

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-04 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: This falls in the category of destabilizing the code for purely cosmetic reasons, and would be a foolish change to make at RC1 time. I suppose. Expect to have more bug reports like this one then though. We could change the text of the ERROR message

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-04 Thread Alvaro Herrera
Gregory Stark escribió: Tom Lane [EMAIL PROTECTED] writes: This falls in the category of destabilizing the code for purely cosmetic reasons, and would be a foolish change to make at RC1 time. I suppose. Expect to have more bug reports like this one then though. We could change the

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-04 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: I don't advocate changing that ERROR to anything else. The message wording, as Tom says, can easily be changed -- I think this patch should be enough. Feel free to propose better wording. Minor gripe: all three variants of the message should follow

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-12-03 Thread Gregory Stark
Alvaro Herrera [EMAIL PROTECTED] writes: Bruce Momjian escribió: Magnus Hagander wrote: On Fri, Nov 30, 2007 at 10:13:53AM +, Gregory Stark wrote: Mike C. [EMAIL PROTECTED] writes: ERROR: canceling statement due to user request CONTEXT: automatic analyze of table

Re: [BUGS] BUG #3790: pg_restore error canceling statement due touser request

2007-11-30 Thread Rodriguez Fernando
como es el pg_dump y pg_restore que usas? Saludos Fernando Mike C. wrote: The following bug has been logged online: Bug reference: 3790 Logged by: Mike C. Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3beta3 Operating system: Linux 2.6.16.21-0.8-xen #1 SMP Mon