Re: Feature discussion: Should syntax errors abort a transaction? - Mailing list pgsql-general

From Jeff Davis
Subject Re: Feature discussion: Should syntax errors abort a transaction?
Date
Msg-id 1340406472.16713.38.camel@sussancws0025
Whole thread Raw
In response to Re: Feature discussion: Should syntax errors abort a transaction?  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
On Wed, 2012-06-20 at 00:24 -0700, Chris Travers wrote:
> I guess it seems to me that I would not object to a new option for
> transaction behavior where one could do something like SET TRANSACTION
> INTERACTIVE; and have no errors abort the transaction at all (explicit
> commit or rollback required) but I would complain loudly if this were
> to be the default, and I don't see a real need for it.

It's already available in psql. See ON_ERROR_ROLLBACK:

http://www.postgresql.org/docs/9.2/static/app-psql.html

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert select fails inside of function
Next
From: Jeff Davis
Date:
Subject: Re: retrieving function raise messages in ecpg embedded sql code