Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT - Mailing list pgsql-patches

Gavin Sherry <swm@linuxworld.com.au> 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