Re: Temporary table weirdness

>>>>> "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