Re: Non-standard feature request - Mailing list pgsql-hackers

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