From: | Gavin Sherry <swm(at)linuxworld(dot)com(dot)au> |
---|---|
To: | Mike Mascari <mascarm(at)mascari(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Non-standard feature request |
Date: | 2002-06-14 09:05:08 |
Message-ID: | Pine.LNX.4.21.0206141833100.876-100000@linuxworld.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Thu, 13 Jun 2002, Mike Mascari wrote:
>
> CREATE TEMPORARY TABLE
> ...
> ON COMMIT DROP;
>
> pseudo-compatible with the SQL-standard of:
>
> ON COMMIT { DELETE | PRESERVE } ROWS;
>
> so one day PostgreSQL's grammar would look like:
>
> ...
> ON COMMIT { DROP | { DELETE | PRESERVE } ROWS };
I think this is a pretty useful feature. Shouldn't require too much
work. A new relkind or a bool in TempTable and a little code in
AtEOXact_temp_relations() to heap_drop_with_catalog() the registered temp
table.
Anyone else keen for this feature?
Gavin
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2002-06-14 09:24:39 | Re: ATTN: Tom Lane |
Previous Message | Tom Lane | 2002-06-14 05:16:40 | Re: Non-standard feature request |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-06-14 10:14:18 | CREATE LANGUAGE/pg_language docs |
Previous Message | Dave Page | 2002-06-14 08:13:36 | Re: FW: Patch for current_schemas to optionally include implicit |