From: | Joseph Barillari <jbarilla(at)princeton(dot)edu> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Temporary table weirdness |
Date: | 2002-04-29 16:07:14 |
Message-ID: | m3pu0ifpzh.fsf@washer.barillari.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
>>>>> "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
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph Barillari | 2002-04-29 16:19:21 | Re: Casting dates |
Previous Message | Josh Berkus | 2002-04-29 16:02:07 | Re: Casting dates |