Re: [HACKERS] Continue transactions after errors in psql - Mailing list pgsql-patches

From Richard Huxton
Subject Re: [HACKERS] Continue transactions after errors in psql
Date
Msg-id 426E4AC1.4070706@archonet.com
Whole thread Raw
In response to Re: [HACKERS] Continue transactions after errors in psql  ("Michael Paesold" <mpaesold@gmx.at>)
Responses Re: [HACKERS] Continue transactions after errors in psql
List pgsql-patches
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

pgsql-patches by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: [HACKERS] Continue transactions after errors in psql
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Continue transactions after errors in psql