> 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?
--
Tatsuo Ishii

In response to

• Re: PL/pgSQL bug? at 2001-09-30 15:35:23 from Tom Lane

Responses

• Re: PL/pgSQL bug? at 2001-10-01 16:58:26 from Tom Lane

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