FAQ

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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 13 of 19 | next ›
Discussion Overview
grouppgsql-patches @
categoriespostgresql
postedJun 8, '04 at 10:24p
activeJun 18, '04 at 11:30p
posts19
users7
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase