Re: Temporary table weirdness - Mailing list pgsql-sql

From Joseph Barillari
Subject Re: Temporary table weirdness
Date
Msg-id m3pu0ifpzh.fsf@washer.barillari.org
Whole thread Raw
In response to Re: Temporary table weirdness  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
>>>>> "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

pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Casting dates
Next
From: Joseph Barillari
Date:
Subject: Re: Casting dates