"Bort, Paul" <pbort@tmwsystems.com> 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