From: Pavel Stehule <pavel.stehule@gmail.com>
To: Marcin Krawczyk <jankes.mk@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: temp table existence
Date: Sat, 29 Dec 2007 20:33:58 +0100
Message-ID: <162867790712291133n1bb6a6fcqeb1234df1576dd8c@mail.gmail.com> (raw)
In-Reply-To: <95f6bf9b0712291116lc3c1df0o978922176e98f8d7@mail.gmail.com>
References: <95f6bf9b0712291116lc3c1df0o978922176e98f8d7@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pavel.stehule@gmail.com, jankes.mk@gmail.com
Subject: Re: temp table existence
In-Reply-To: <162867790712291133n1bb6a6fcqeb1234df1576dd8c@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox