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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster