Re: Vote totals for SET in aborted transaction - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: Vote totals for SET in aborted transaction
Date
Msg-id 3CCD66F4.6E4877CA@fourpalms.org
Whole thread Raw
In response to Re: Vote totals for SET in aborted transaction  (Scott Marlowe <scott.marlowe@ihs.com>)
List pgsql-hackers
> I've been thinking this over and over, and it seems to me, that the way
> SETS in transactions SHOULD work is that they are all rolled back, period,
> whether the transaction successfully completes OR NOT.

Very interesting! This is a *consistant* use of SET which allows
transactions to be constructed as self-contained units without
side-effects on subsequent transactions. Beautifully powerful.
                 - Thomas

I've got some other thoughts on features for other aspects of schemas
and table and query properties, but this proposal for SET behavior
stands on its own so I'll hold off on muddying the discussion.


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Vote totals for SET in aborted transaction
Next
From: Tom Lane
Date:
Subject: Re: Vote totals for SET in aborted transaction