Temp Tables - Mailing list pgsql-sql

From sad
Subject Temp Tables
Date
Msg-id 200409271712.21053.sad@bankir.ru
Whole thread Raw
In response to Re: postgres rpm  (Devrim GUNDUZ <devrim@gunduz.org>)
List pgsql-sql
Hi

I propose you again a topic for discuss.

Do you find useful the clause "ON COMMIT DELETE ROWS" ?
like Oracle allows to specify for a temporery table

And is it necessary to delete temp table from The Dictionary wherever
disconnect and recrete it each session it needed ? (I mean that some problems
better to solve with so-called GLOBAL TEMP TABLEs which are created once the
DB created and DBMS keeps them empty (by ON COMMIT DELETE ROWS) and only own
rows each user sees in a transaction)




pgsql-sql by date:

Previous
From: Greg Stark
Date:
Subject: Re: COUNT(*) to find records which have a certain number of dependencies
Next
From: Achilleus Mantzios
Date:
Subject: FOREIGN KEY and AccessExclusiveLock