Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: plpgsql temporary table problem
Date
Msg-id 22115.1018803485@sss.pgh.pa.us
Whole thread Raw
In response to Re: plpgsql temporary table problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: plpgsql temporary table problem
List pgsql-general
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> ... I believe every reference to the TEMP table has
> to be an EXECUTE.  I think this will be fixed in 7.3 because the temp
> tables will exist in a separate schema.

No, the separate schema won't help matters a bit.

Plan dependency tracking (to allow us to drop invalidated cached plans)
would help.

            regards, tom lane

pgsql-general by date:

Previous
From: Matthew Kirkwood
Date:
Subject: Re: [GENERAL] Performance Tuning Document?
Next
From: Bruce Momjian
Date:
Subject: Re: plpgsql temporary table problem