Horton

Re: [HACKERS] psql and libpq fixes

Bruce Momjian <pgman@candle.pha.pa.us>

View thread
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Peter Eisentraut <peter_e@gmx.net>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-02-08T16:38:53Z
Lists: pgsql-hackers 
> 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, Pennsylvania 19026