"Bort, Paul" <[EMAIL PROTECTED]> writes: > Would it make more sense to specify at the time the optional subtransaction > is committed that it is not critical to the completion of the outer > transaction? > > BEGIN; > BEGIN; > DROP TABLE foo; > COMMIT NON_CRITICAL; > CREATE TABLE foo (i int); > COMMIT;
I assumed that was what was being proposed. It doesn't make sense to have a single flag on the entire outer transaction since there could have been multiple inner transactions, not all of which are unimportant. Hm, perhaps a parallel to "CREATE OR REPLACE" would be "COMMIT OR ROLLBACK". I'm not sure if I'm serious about that or joking though. -- greg ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]