Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)

From: Daniel Schuchardt <daniel_schuchardt(at)web(dot)de>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)
Date: 2006-01-17 14:44:15
Message-ID: dqivrp$2ok5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

here is a testcase:

CREATE OR REPLACE FUNCTION testseq()
RETURNS void AS
$BODY$
BEGIN
CREATE TEMP SEQUENCE test;
PERFORM testseq1();
DROP SEQUENCE test;
RETURN;
END; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION testseq() OWNER TO postgres;

CREATE OR REPLACE FUNCTION testseq1()
RETURNS void AS
$BODY$
DECLARE I INTEGER;
BEGIN
I:= nextval('test');
RETURN;
END; $BODY$
LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION testseq1() OWNER TO postgres;

SELECT testseq();

-- this works fine.

SELECT testseq();

ERROR: could not open relation with OID 21152
CONTEXT: PL/pgSQL function "testseq1" line 3 at assignment
SQL statement "SELECT testseq1()"
PL/pgSQL function "testseq" line 3 at perform

Greetings,

Daniel.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2006-01-17 14:44:30 Re: Docs off on ILIKE indexing?
Previous Message Magnus Hagander 2006-01-17 12:53:22 Bad estimate on LIKE matching