Re: PL/perl elog(ERROR) Does not Abort Transaction - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/perl elog(ERROR) Does not Abort Transaction
Date
Msg-id 8223.1336756755@sss.pgh.pa.us
Whole thread Raw
In response to Re: PL/perl elog(ERROR) Does not Abort Transaction  ("David E. Wheeler" <david@justatheory.com>)
List pgsql-hackers
"David E. Wheeler" <david@justatheory.com> writes:
> On May 11, 2012, at 9:51 AM, David E. Wheeler wrote:
>> \set ON_ERROR_ROLLBACK interactive
>> 
>> So I guess it transparently rolls back a savepoint for the previous statement. I had forgotten I turned that on.
Apologiesfor the noise.
 

Ah-hah.

> OTOH, might it be useful to have psql show some sort of status message when it does this?

The same occurred to me, but after more thought I think it'd just be
horribly annoying after a short time.  People who have this set will
(or should, anyway) be expecting errors to be nonfatal to their
transactions.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Gsoc2012 idea, tablesample
Next
From: Robert Haas
Date:
Subject: Re: WalSndWakeup() and synchronous_commit=off