--On Samstag, Juli 25, 2009 16:00:18 +0300 Peter Eisentraut
> When you run a file with psql -1/--single-transaction, and a command
> fails, you get bombarded with
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
> for the rest of the file.
> Shouldn't -1 imply ON_ERROR_STOP or some variant by default?
Only if it could ensured that embedded SAVEPOINTS can be handled
properly...a quick check shows that ON_ERROR_STOP will stop any script even
when the errorneous command is probably rolled back by a subsequent
SELECT et; <-- ON_ERROR_STOP stops here
ROLLBACK TO A;
It seems -1 needs some smarter variant of ON_ERROR_STOP.
pgsql-hackers by date
|Next:||From: Robert Haas||Date: 2009-07-25 21:31:51|
|Subject: Re: Patch for 8.5, transformationHook|
|Previous:||From: Robert Haas||Date: 2009-07-25 20:39:29|
|Subject: Re: SE-PostgreSQL Specifications|