Skip site navigation (1) Skip section navigation (2)

Re: plpgsql TEMP table issue not fixed in 8.1?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Jim Klo <jklo(at)webassociates(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: plpgsql TEMP table issue not fixed in 8.1?
Date: 2005-12-16 18:56:31
Message-ID: 1134759391.9142.46.camel@localhost.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
On Thu, 2005-12-15 at 11:09 -0800, Jim Klo wrote:
> I’m having a similar problem:
>  
> ERROR:  relation with OID 7121526 does not exist
> CONTEXT:  SQL statement "SELECT  * INTO  temp tmp_resourcequeue from resourcequeue where timeblockid in (select timeblockid from tmp_timeblock)"
> PL/pgSQL function "archivetimeblocks" line 54 at SQL statement
>  
> Works the first time, but not the second… even tho the temp table has been explicitly dropped between executions.
>  
> Is there a fix or workaround for this yet?

Only the workarounds that have always existed: drop and recreate the
function, disconnect and then reconnect the client application, or
reference the temp table using EXECUTE only. The underlying problem
(invalidation of cached query plans) has not yet been fixed.

-Neil



In response to

pgsql-bugs by date

Next:From: Alvaro HerreraDate: 2005-12-16 19:11:17
Subject: Re: Postgres 8.1 hangs at boot time due to password authentication for user postgres.
Previous:From: Rolf GrossDate: 2005-12-16 18:37:52
Subject: Postgres 8.1 hangs at boot time due to password authentication for user postgres.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group