On Fri, 18 Mar 2005, Oliver Siegmar wrote:
> On Friday 18 March 2005 14:29, Stephan Szabo wrote:
> > Given the error message, this seems to be the whole plpgsql caches query
> > plans but we don't invalidate those plans when there are schema changes.
> I already tried to execute the 'CREATE TEMP TABLE' statement using EXECUTE to
> avoid cache problems - same problem!
You have to EXECUTE the insert as well.
In response to
pgsql-bugs by date
|Next:||From: Bruce Momjian||Date: 2005-03-18 17:08:35|
|Subject: Re: Possible temp table bug in PostgreSQL 7.4.7 / 8.0.1|
|Previous:||From: Oliver Siegmar||Date: 2005-03-18 13:58:59|
|Subject: Re: BUG #1546: Temp table isn't deleted at the end of a transaction / ON COMMIT DROP has no effect|