Skip site navigation (1) Skip section navigation (2)

Re: temporary table

From: Andrew Snow <andrew(at)modulus(dot)org>
To: jack <datactrl(at)tpg(dot)com(dot)au>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: temporary table
Date: 2001-10-26 05:48:05
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
How about using the procedure only within a transaction - if something goes
wrong, the transaction can be aborted and all temporary tables will vanish,
meaning you can start a new transaction and call the procedure again without
worrying whether the temp tables exist.

- Andrew

On Fri, 26 Oct 2001, jack wrote:

> HI, all
> Temporary tables created by "CREATE TABLE" or by "SELECT ..INTO" are so hard
> to handle. If it doesn't exist, then "drop" cuases an error. If the same
> procedure runs second time without dropping all temporary tables, providing
> still in the same connection session, then procedure causes "table exists"
> error. And it's unable to search system table to find whether it exists or
> not. Is that possible to have a command like "drop table if exist"? Please
> provide advices, thank you!
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

In response to

pgsql-general by date

Next:From: Stephan BergmannDate: 2001-10-26 06:24:24
Subject: Directory Names????
Previous:From: Seth HettichDate: 2001-10-26 05:10:46
Subject: initdb segfault - solaris 8

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group