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

Поиск
Список
Период
Сортировка
От Daniel Schuchardt
Тема Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)
Дата
Msg-id dqivrp$2ok5$1@news.hub.org
обсуждение исходный текст
Ответы Re: Error working with Temporary Sequences in plpgsql in 8.1 (8.0 works fine)  (Jaime Casanova <systemguards@gmail.com>)
Список pgsql-hackers
Hi,

here is a testcase:

CREATE OR REPLACE FUNCTION testseq() RETURNS void AS
$BODY$
BEGINCREATE 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;
BEGINI:= 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.


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Magnus Hagander"
Дата:
Сообщение: Bad estimate on LIKE matching
Следующее
От: "Magnus Hagander"
Дата:
Сообщение: Re: Docs off on ILIKE indexing?