Re: temp table existence

[aklaver(at)comcast(dot)net (Adrian Klaver)]

------------- Original message ----------------------
From: "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>
> Hi all. Is there a way to determine the existence of a TEMP
> TABLE? I need to check i it exists before I create it. Doing simple
> check on pg_class or pg_tables is
> not enough because there may be other such tables created in other sessions.
> Or maybe anyone knows the identification (apart from 'others') of error to
> trap it with EXCEPTION clause?

select  *  from temp_table limit 1;
Trap error 42P01 Undefined table.

--
Adrian Klaver
aklaver(at)comcast(dot)net

 -

--- Begin Message ---

• From: "Marcin Krawczyk" <jankes(dot)mk(at)gmail(dot)com>
• To: pgsql-sql(at)postgresql(dot)org
• Subject: [SQL] temp table existence
• Date: Sat, 29 Dec 2007 19:18:28 +0000

Hi all. Is there a way to determine the existence of a TEMP TABLE? I need to check i it exists before I create it. Doing simple check on pg_class or pg_tables is
not enough because there may be other such tables created in other sessions. Or maybe anyone knows the identification (apart from 'others') of error to trap it with EXCEPTION clause?

--- End Message ---