plpgsql TEMP table issue not fixed in 8.1?

Started by Josh Berkusover 20 years ago2 messagesbugs
Jump to latest
#1Josh Berkus
josh@agliodbs.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Josh Berkus (#1)
Re: plpgsql TEMP table issue not fixed in 8.1?

Josh Berkus <josh@agliodbs.com> writes:

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

Nope.

regards, tom lane