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

From Rafal Pietrak
Subject Re: Feature discussion: Should syntax errors abort a transaction?
Date
Msg-id 1340180039.28999.6.camel@localhost.localdomain
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.

Awesome!

Or rather: "BEGIN [INTERACTIVE];" (mind the <TAB>) for a one shot
interaction.

-R


pgsql-general by date:

Previous
From: Sumit Raja
Date:
Subject: Re: db server processes hanging around
Next
From: "Dr. F. Lee"
Date:
Subject: View parsing