Re: Temporary table weirdness

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

TL> In the meantime, you need to use EXECUTE to defeat the plan
TL> caching for every plpgsql query that touches the temp 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