Re: Checking existence of temporary table

From: ranavikas(at)gmail(dot)com (Vikas Rana)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Checking existence of temporary table
Date: 2004-07-30 06:10:56
Message-ID: 7889b359.0407292159.2f5fdb30@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well, I solved it myself after some more debugging!!

Turns out that different connections were being used for creating the
temporary tables and checking the existence of the table. Temporary
tables, being connection specific, are not visible across connections.
The temporary tables, like all other tables, are also listed in
pg_tables.

Sorry for the trouble folks!!

Regards,

Vikas

Browse pgsql-general by date

  From Date Subject
Next Message Secrétariat 2004-07-30 08:17:20 Using view
Previous Message Bruce Momjian 2004-07-30 04:34:57 Re: Wal logs