Re: [HACKERS] Continue transactions after errors in psql

Michael Paesold wrote:
>
> But people (like me for example) will want to enable this behaviour by
> default. So they (me too) will put the option in .psqlrc. It is then
> enabled "by default". But then many of my scripts will destroy data
> instead of just erroring out.
> I just don't see why non-interactive mode does need such a switch
> because there is no way to check if there was an error. So just put two
> queries there and hope one will work?

DROP TABLE foo;
CREATE TABLE foo...

--
   Richard Huxton
   Archonet Ltd