Re: [HACKERS] Continue transactions after errors in psql

From: Richard Huxton <dev(at)archonet(dot)com>
To: Michael Paesold <mpaesold(at)gmx(dot)at>
Cc: Greg Sabino Mullane <greg(at)turnstep(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Continue transactions after errors in psql
Date: 2005-04-26 14:05:53
Message-ID: 426E4AC1.4070706@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-26 14:28:53 Re: [HACKERS] Continue transactions after errors in psql
Previous Message Michael Paesold 2005-04-26 12:22:03 Re: [HACKERS] Continue transactions after errors in psql

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2005-04-26 14:28:53 Re: [HACKERS] Continue transactions after errors in psql
Previous Message Michael Paesold 2005-04-26 12:22:03 Re: [HACKERS] Continue transactions after errors in psql