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!
>
>
> JACK
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>