Temporary table visibility

From: James Croft <james(dot)croft(at)lumison(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Temporary table visibility
Date: 2006-01-25 11:42:07
Message-ID: 6CFE3EF0-642B-4D4F-9908-DA637A6DE2FF@lumison.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi all,

I've had a look at through the list archives but haven't found an
answer to this one. Any suggestions appreciated (aside from ones
suggesting that I should not need to do this ;-)...

- A normal table foo is created in a database.
- Clients connect to the database, some create a temp table foo some
don't.

(only one postgresql user is being used to connect to the database if
that matters)

How does a client determine if table foo is temporary or not?

Or put another way...

How can I determine what temporary tables exist in my session,
bearing in mind that other sessions contain temp tables using the
same names?

Many thanks,

James
--

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender. Any
offers or quotation of service are subject to formal specification.
Errors and omissions excepted. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of Lumison, nplusone or lightershade ltd.
Finally, the recipient should check this email and any attachments for the
presence of viruses. Lumison, nplusone and lightershade ltd accepts no
liability for any damage caused by any virus transmitted by this email.

--
--
Virus scanned by Lumison.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ilja Golshtein 2006-01-25 13:22:09 table is not a table
Previous Message Marcos 2006-01-25 11:31:55 Tsearch 2