| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | mike stanton <mstanton(at)acsa(dot)cl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: refcursor |
| Date: | 2008-09-01 15:52:40 |
| Message-ID: | 20080901155240.GF3776@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
mike stanton escribió:
>
> Hello all,
> I've got a problem I can't get round. I want to declare a refcursor variable in a C program and call a function which returns a refcursor portal to the main C program.
> When I compile the C program, I get a refcursor doesn´t exist message.
> Has anyone got a C program which uses a refcursor variable?
Make sure the C program opens a transaction before calling the function,
otherwise the cursor is automatically closed as soon as the function ends.
--
Alvaro Herrera Valdivia, Chile Geotag: -39,815 -73,257
"Ah, spring... when a young penguin's fancy lightly turns to thoughts of ...
Beta testing!" (Fedora 9 beta announcement)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edoardo Panfili | 2008-09-01 16:24:47 | immutable functions and enumerate type casts in indexes |
| Previous Message | David Fetter | 2008-09-01 14:59:08 | Re: Oracle and Postgresql |