Horton

Re: [HACKERS] Continue transactions after errors in psql

Richard Huxton <dev@archonet.com>

View thread
From: Richard Huxton <dev@archonet.com>
To: Michael Paesold <mpaesold@gmx.at>
Cc: Greg Sabino Mullane <greg@turnstep.com>, pgsql-hackers@postgresql.org, pgsql-patches@postgresql.org
Date: 2005-04-26T14:05:53Z
Lists: pgsql-hackers 
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