Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-patches by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group