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

plpgsql TEMP table issue not fixed in 8.1?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: plpgsql TEMP table issue not fixed in 8.1?
Date: 2005-09-01 00:18:35
Message-ID: 200508311718.35457.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Folks,

I'd swear somebody committed a fix for the issue with temp tables inside 
plpgsql functions, like, months ago.  Yet I still get:

ERROR:  relation with OID 16607 does not exist
CONTEXT:  SQL statement "INSERT INTO tmp_runs ( run_id, batch, machine ) 
VALUES ( NEXTVAL('runs_run_id_seq'),  $1 ,  $2 [ $3 ] )"
        PL/pgSQL function "generate_test_series" line 67 at SQL statement
ERROR:  relation with OID 16607 does not exist

This is CVS as of a week ago.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2005-09-01 02:06:58
Subject: Re: plpgsql TEMP table issue not fixed in 8.1?
Previous:From: Bruce MomjianDate: 2005-08-31 21:33:23
Subject: Re: [BUGS] PSQL commands not backwards-compatible

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