Re: Possible Bug regarding temp tables (sql or psql?)

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-05 02:02:02
Message-ID: GNELIHDDFBOCMGBFGEFOOEPICCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-sql

IIRC they are only visible in the connection that created them? Am I right?
Either way, I don't think \d will show them - there might be another
command...

Chris

> Any idea why the table can't be seen with \d in psql then?
>
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> [02/07/04 00:21]:
> >
> > 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.

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Bruce Momjian 2002-07-05 02:09:27 Re: Possible Bug regarding temp tables (sql or psql?)
Previous Message Stavros Karposilos 2002-07-05 00:51:30 MS Access 2K Inform User on Record changes

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-07-05 02:09:27 Re: Possible Bug regarding temp tables (sql or psql?)
Previous Message Arjen van der Meijden 2002-07-04 21:32:20 Re: Boolean to int