Thread: stopping execution of a script (on error)

stopping execution of a script (on error)

From

Olivier Chapiteau

Date:

14 June 2001, 15:06:39

Is it possible to stop the execution of a sql script in case of problem ?

ex :

create table newtable as select * from oldtable
DROP TABLE oldtable

I don't want to drop the table if the first instruction did not work properly

Re: stopping execution of a script (on error)

From

Peter Eisentraut

Date:

14 June 2001, 16:04:19

Olivier Chapiteau writes:

> Is it possible to stop the execution of a sql script in case of problem ?
>
> ex :
>
> create table newtable as select * from oldtable
> DROP TABLE oldtable
>
> I don't want to drop the table if the first instruction did not work properly

In psql:

\set ON_ERROR_STOP

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter