Re: temporary tables, plpgsql and yes i bet this has been asked before - Mailing list pgsql-sql

From Tom Lane
Subject Re: temporary tables, plpgsql and yes i bet this has been asked before
Date
Msg-id 2301.1012837625@sss.pgh.pa.us
Whole thread Raw
In response to temporary tables, plpgsql and yes i bet this has been asked before  (Murray Prior Hobbs <murray@efone.com>)
List pgsql-sql
Murray Prior Hobbs <murray@efone.com> writes:
> in a plpgsql function
>     create temporary table X
>     ....
>     drop table X

You need to use EXECUTE for all accesses to the temp table, in order
to defeat plpgsql's attempts to cache plans for those queries.
        regards, tom lane


pgsql-sql by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: casting question
Next
From: Jan Wieck
Date:
Subject: Re: temporary tables, plpgsql and yes i bet this has been asked