Re: temporary tables, plpgsql and yes i bet this has been asked before

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Murray Prior Hobbs <murray(at)efone(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: temporary tables, plpgsql and yes i bet this has been asked before
Date: 2002-02-04 15:47:05
Message-ID: 2301.1012837625@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Murray Prior Hobbs <murray(at)efone(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Wieck 2002-02-04 20:06:26 Re: temporary tables, plpgsql and yes i bet this has been asked
Previous Message Jeff Eckermann 2002-02-04 15:05:30 Re: casting question