Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables... - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...
Date
Msg-id 469C7011.8080404@enterprisedb.com
Whole thread Raw
In response to BUG #3450: Multiple Stored procedure calls cause issue with temp tables...  ("Chris Bowlby" <excalibur@accesswave.ca>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: "Chris Bowlby"
Date:
Subject: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...
Next
From: Neil Conway
Date:
Subject: Re: BUG #3450: Multiple Stored procedure calls cause issue with temp tables...