Re: Nested transactions - Mailing list pgsql-patches

From Simon Riggs
Subject Re: Nested transactions
Date
Msg-id 1087507163.12015.5100.camel@stromboli
Whole thread Raw
In response to Re: Nested transactions  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-patches
On Thu, 2004-06-17 at 02:44, Alvaro Herrera wrote:
> I don't know what Oracle or other DBMSs expect in this area.  Anyone
> care to give me a few pointers?  If I'm missing something, I want to
> know as soon as possible.

Without ignoring your other responses, I remain massively impressed....

SAVEPOINTs allow you to split a transaction into multiple related parts.

You can issue:
(implicit start)
statement1
statement2
statement3 - causes error - note does not rollback txn
reissue statement3
SAVEPOINT X
statement 4 - succeeds
ROLLBACK to X (undoes statement 4, but not statement 3)
statement 5
COMMIT

statements 1,2,3,5 are committed


Best Regards, Simon Riggs



pgsql-patches by date:

Previous
From: Barry Lind
Date:
Subject: Re: Nested transactions
Next
From: Bruce Momjian
Date:
Subject: Re: Nested transactions