Postgres Pro
Downloads
Home   >   mailing lists

Re: PL/pgSQL bug? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PL/pgSQL bug?
Date
Msg-id 2072.1001864123@sss.pgh.pa.us
Whole thread Raw
In response to PL/pgSQL bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: PL/pgSQL bug?  (Tatsuo Ishii <t-ishii@sra.co.jp>)
List pgsql-hackers
Tree view 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Maybe PL/pgSQL cache problem?

This is a well-known problem: plpgsql caches a query plan that refers
to the first version of the temp table, and it doesn't know it needs
to rebuild the plan.  AFAIK the only workaround at present is to use
EXECUTE for queries referencing the temp table.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Glitch in handling of postmaster -o options
Next
From: Bradley McLean
Date:
Subject: Re: Pre-forking backend