Re: temp table existence - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: temp table existence
Date
Msg-id 162867790712291133n1bb6a6fcqeb1234df1576dd8c@mail.gmail.com
Whole thread Raw
In response to temp table existence  ("Marcin Krawczyk" <jankes.mk@gmail.com>)
Responses Re: temp table existence
List pgsql-sql
Hello

On 29/12/2007, Marcin Krawczyk <jankes.mk@gmail.com> wrote:
> 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?
>

http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL

Regards
Pavel Stehule


pgsql-sql by date:

Previous
From: "Marcin Krawczyk"
Date:
Subject: temp table existence
Next
From: "Marcin Krawczyk"
Date:
Subject: Re: temp table existence