Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Chris Bowlby <excalibur(at)accesswave(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...
Date: 2007-07-17 07:30:25
Message-ID: 469C7011.8080404@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Chris Bowlby wrote:
> Using a temporary table of the same name in repeated calls to a stored
> procedure are causing OID failure issues, it can be re-created using the
> following useless example:

This is an unfortunate side-effect of caching access plans in PL/PgSQL
functions, see FAQ:

http://www.postgresql.org/docs/faqs.FAQ.html#item4.19

The upcoming 8.3 release will include plan invalidation, which will fix
this issue.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Neil Conway 2007-07-17 07:32:47 Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...
Previous Message ITAGAKI Takahiro 2007-07-17 06:48:14 Re: BUG #3453: Error on COPY TO/FROM 'non-ascii-path'