refcursor
От | Oliver Vecernik |
---|---|
Тема | refcursor |
Дата | |
Msg-id | 3E1804ED.50203@aon.at обсуждение исходный текст |
Ответы |
Re: refcursor
|
Список | pgsql-general |
Hi! I'm playing with refcursor, but I'm not successful. I defined follwing function: CREATE OR REPLACE FUNCTION stat() RETURNS refcursor AS ' DECLARE ref refcursor; BEGIN OPEN ref FOR SELECT * FROM tagebuch; RETURN ref; END; ' LANGUAGE 'plpgsql'; Trying to see some results gives me: sport=# select stat(); ERROR: fmgr_info: function 16556: cache lookup failed sport=# select version(); version --------------------------------------------------------------- PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4 (1 row) sport=# select * from tagebuch; ... This works fine. I receive the same error when I try to call stat() from Python with pyPgSQL-DBI adaptor. What am I doingwrong (PostgreSQL runs on a Debian/Woody box)? Regards, Oliver -- VECERNIK Datenerfassungssysteme A-2560 Hernstein, Hofkogelgasse 17 Tel.: +43 2633 47530, Fax: DW 50 http://members.aon.at/vecernik
В списке pgsql-general по дате отправления: