| From: | sad <sad(at)bankir(dot)ru> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Temp Tables |
| Date: | 2004-09-27 13:12:21 |
| Message-ID: | 200409271712.21053.sad@bankir.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Stark | 2004-09-27 13:27:26 | Re: COUNT(*) to find records which have a certain number of dependencies |
| Previous Message | T E Schmitz | 2004-09-27 09:45:01 | Re: COUNT(*) to find records which have a certain number of |