> This is a well-known problem: plpgsql caches a query plan that refers
> to the first version of the temp table, and it doesn't know it needs
> to rebuild the plan. AFAIK the only workaround at present is to use
> EXECUTE for queries referencing the temp table.
But EXECUTE does not support select into, does it?
In response to
pgsql-hackers by date
|Next:||From: Steve Wolfe||Date: 2001-10-01 02:16:27|
|Subject: Re: Pre-forking backend|
|Previous:||From: Bruce Momjian||Date: 2001-10-01 00:53:47|
|Subject: Re: CVS changes|