From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [HACKERS] CREATE TEMP TABLE .... ON COMMIT |
Date: | 2002-08-14 05:23:30 |
Message-ID: | 200208140523.g7E5NUe01345@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Gavin, was this addressed?
---------------------------------------------------------------------------
Tom Lane wrote:
> Gavin Sherry <swm(at)linuxworld(dot)com(dot)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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Gavin Sherry | 2002-08-14 05:24:30 | Re: journaling in contrib ... |
Previous Message | Bruce Momjian | 2002-08-14 05:21:34 | Re: Better handling of parse errors |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-14 05:25:04 | Re: pg_settings view |
Previous Message | Bruce Momjian | 2002-08-14 05:21:34 | Re: Better handling of parse errors |