From: Pavel Stehule <pavel.stehule@gmail.com>
To: Erik Jones <erik@myemma.com>
Cc: Marcin Krawczyk <jankes.mk@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: temp table existence
Date: Sun, 30 Dec 2007 09:44:46 +0100
Message-ID: <162867790712300044w78a4e633kaccc5e9e4d15dd28@mail.gmail.com> (raw)
In-Reply-To: <429CBCF5-217F-49A9-959B-9D20CA7CC64C@myemma.com>
References: <95f6bf9b0712291116lc3c1df0o978922176e98f8d7@mail.gmail.com>
<162867790712291133n1bb6a6fcqeb1234df1576dd8c@mail.gmail.com>
<95f6bf9b0712291316x31ae9c8er80fb60a7db4aaca6@mail.gmail.com>
<429CBCF5-217F-49A9-959B-9D20CA7CC64C@myemma.com>
Hello
On 30/12/2007, Erik Jones <erik@myemma.com> wrote:
>
> On Dec 29, 2007, at 3:16 PM, Marcin Krawczyk wrote:
>
> > I just realized something... my bad. It will work since TRUNCATE
> > removes only table from current session.
>
> If the table exists and you're going to TRUNCATE it before using it,
> you could just use DROP TABLE IF EXISTS and then create it. I don't
> know, that feels cleaner to me than TRUNCATEing a table that might
> not be available to the session.
>
if you drop temp table in session, you lost all prepared statements
related to table. before 8.3 it means runtime error, now only less
efectivity.
> Erik Jones
>
> Software Developer | Emma(R)
> erik@myemma.com
> 800.595.4401 or 615.292.5888
> 615.292.0777 (fax)
>
> Emma helps organizations everywhere communicate & market in style.
> Visit us online at http://www.myemma.com
>
>
>
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, erik@myemma.com, jankes.mk@gmail.com
Subject: Re: temp table existence
In-Reply-To: <162867790712300044w78a4e633kaccc5e9e4d15dd28@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