stopping execution of a script (on error)

From: Olivier Chapiteau <ochapiteau(at)cyberdeck(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: stopping execution of a script (on error)
Date: 2001-06-14 15:46:59
Message-ID: 01061417465900.02610@ochapiteau.dagon.pdt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-14 16:34:55 Re: stopping execution of a script (on error)
Previous Message Lamar Owen 2001-06-14 15:16:14 Re: Log files, how to rotate properly