| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Geoff Russell <geoff(at)austrics(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: plpgsql temporary table problem |
| Date: | 2002-04-14 17:36:26 |
| Message-ID: | 22499.1018805786@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Tom Lane wrote:
>> No, the separate schema won't help matters a bit.
> Oh, the old temp code mapped a temp name to a system table name that was
> stored in the plpgsql function cache. I thought the new code would not
> make that mapping until function runtime.
The point is that cached plans refer to tables by OID.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lamar Owen | 2002-04-14 18:35:13 | Redhat 7.2.93 performance (was:Re: PostgreSQL 7.2.1-2PGDG RPMs available for RedHat-skipjack 7.2.93 and RedHat 6.2/SPARC) |
| Previous Message | Bruce Momjian | 2002-04-14 17:15:44 | Re: plpgsql temporary table problem |