hello,
it's not bug. Please look on
http://www.pgsql.cz/index.php/Automatic_execution_plan_caching_in_PL/pgSQL
Regards
Pavel Stehule
2007/7/17, Chris Bowlby <[EMAIL PROTECTED]>:
The following bug has been logged online:
Bug reference: 3450
Logged by: Chris Bowlby
Email address:
On Tue, 2007-17-07 at 00:51 +, Chris Bowlby wrote:
> Using a temporary table of the same name in repeated calls to a stored
> procedure are causing OID failure issues
This is a (well) known bug. The problem arises because plpgsql caches
the query plan used to access the temporary table, which
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://ww
The following bug has been logged online:
Bug reference: 3450
Logged by: Chris Bowlby
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.11
Operating system: SUSE Linux Enterprise Server 9 SP2
Description:Multiple Stored procedure calls cause issue with temp
tab
