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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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