On Fri, 14 Jun 2002, Gavin Sherry wrote: > 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?
Attached is a patch implementing this. The patch is against 7.2.1 source. The grammar introduced is of the form: CREATE TEMP TABLE ... ON COMMIT DROP; Is this a desirable feature? Seems pretty useful to me. Gavin
temprel.diff.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly