>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.us> writes:
TL> In the meantime, you need to use EXECUTE to defeat the plan TL> caching for every plpgsql query that touches
thetemp table. TL> Another answer is to arrange to create the temp table only TL> once per session, but that's
harder.
That's actually what I did -- the client programs in this application
have to call a function to create the various temporary tables at the
start of their database sessions. It's a bit of a kludge, but there
are only a few client applications which talk to this database.
Regards,
Joe Barillari