Gavin Sherry <[EMAIL PROTECTED]> writes:
> As for your question (and, perhaps, SQL99) I don't seen how it makes any
> sense to specify ON COMMIT outside of a transaction block.
Surely it does.
CREATE TEMP TABLE foo(...) ON COMMIT DELETE ROWS;
BEGIN;
insert some rows in foo;
process rows in foo;
COMMIT; -- foo is now empty again
BEGIN;
insert some rows in foo;
process rows in foo;
COMMIT; -- foo is now empty again
repeat until application quit...
What am I missing?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
