From: | Oliver Vecernik <vecernik(at)aon(dot)at> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | refcursor |
Date: | 2003-01-05 10:11:57 |
Message-ID: | 3E1804ED.50203@aon.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 doing wrong (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
From | Date | Subject | |
---|---|---|---|
Next Message | Lincoln Yeoh | 2003-01-05 11:14:46 | Re: select for update with left outer joins? |
Previous Message | Justin Clift | 2003-01-05 09:22:02 | Which 4GL application development tools are available? |