| 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: | Whole Thread | Raw Message | 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? |