Bruce Momjian <pgman@candle.pha.pa.us> writes:
>> This does bring up a thought --- should psql's kill-the-script-on-error
>> option perhaps zap the script only for errors committed outside of a
>> transaction block?
> Why is being in a transaction block important?
I was thinking that the script might be expecting an error, and have
established a begin-block to limit the effects of the error.
But on third thought, probably the thing that would be really useful
for "expected errors" is if there is a backslash-command that turns on
or off the kill-on-error behavior. (The command line switch would
merely set the initial state of this flag.) This way, a script could
use the option in an intelligent fashion:
\kill-on-error offDROP TABLE t1;\kill-on-error onCREATE TABLE t1;...
It'd still have to default to 'off' for backwards compatibility,
unfortunately, but something like this would be really useful.
regards, tom lane