Re: [PATCHES] Continue transactions after errors in psql - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] Continue transactions after errors in psql
Date
Msg-id 1752.1114525733@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Continue transactions after errors in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: [PATCHES] Continue transactions after errors in  (Philip Warner <pjw@rhyme.com.au>)
Re: [PATCHES] Continue transactions after errors in psql  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: [PATCHES] Continue transactions after errors in psql  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-hackers
"Greg Sabino Mullane" <greg@turnstep.com> writes:
> To reiterate my opinion, I think the behavior should be the same
> for interactive and non-interactive sessions. Not only will it
> prevent nasty surprises, but unless we make a third 'setting',
> there will be no way to enable this in non-interactive scripts,
> which is something that I would want to be able to do.

I'm finding it hard to visualize a non-interactive script making
any good use of such a setting.  Without a way to test whether
you got an error or not, it would amount to an "ignore errors
within transactions" mode, which seems a pretty bad idea.

Can you show a plausible use-case for such a thing?

            regards, tom lane

pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: [PATCHES] Continue transactions after errors in psql
Next
From: "Michael Paesold"
Date:
Subject: Re: [PATCHES] Continue transactions after errors in psql