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)
In response to
pgsql-sql by date
|Next:||From: Greg Stark||Date: 2004-09-27 13:27:26|
|Subject: Re: COUNT(*) to find records which have a certain number of dependencies|
|Previous:||From: T E Schmitz||Date: 2004-09-27 09:45:01|
|Subject: Re: COUNT(*) to find records which have a certain number of|