> 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 off
> DROP TABLE t1;
> \kill-on-error on
> CREATE TABLE t1;
> ...
>
> It'd still have to default to 'off' for backwards compatibility,
> unfortunately, but something like this would be really useful.
In Informix 4GL, it is ON ERROR STOP and ON ERROR CONTINUE.
-- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026