| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Mark Frazer" <mark(at)somanetworks(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Possible Bug regarding temp tables (sql or psql?) |
| Date: | 2002-07-04 01:38:33 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOOEONCCAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-interfaces pgsql-sql |
> Forgot to mention that adding
> DROP TABLE v_idx ;
> before the END WORK will fix things. However, I was under the
> impression that
> temporary tables would go away after a transaction in which they
> were created
> was committed.
No - they go away at the end of a _connection_. However, there is now a
patch floating around on -hackers that would add an ' ON COMMIT DROP;'
option to CREATE TEMP TABLE.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2002-07-04 07:25:41 | Re: PgAdmin II - Connection to only one Database |
| Previous Message | Mark Frazer | 2002-07-03 21:12:32 | Re: Possible Bug regarding temp tables (sql or psql?) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rudi Starcevic | 2002-07-04 01:47:58 | Re: Selecting data from a table created in another database... |
| Previous Message | Stephan Szabo | 2002-07-03 23:43:26 | Re: How do I access the current row from a trigger? |