Re: plpgsql temporary table problem - Mailing list pgsql-general

From Tom Lane
Subject Re: plpgsql temporary table problem
Date
Msg-id 22499.1018805786@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql temporary table problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian <pgman@candle.pha.pa.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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: plpgsql temporary table problem
Next
From: Michael Loftis
Date:
Subject: Re: Scaling postgres