Hi,
I have question about fetching data from refcursor, why this operation
required to be inside transaction?
for example
with transaction
begin;
select * from foo();
fetch all from "<unnamed portal 1>";
commit;
when I try this without transaction I get error
select * from foo();
fetch all from "<unnamed portal 1>";
ERROR: cursor "<unnamed portal 1>" does not exist
why cursor "<unnamed portal 1>" are not defined in session and required
transaction?
best regards,
Wojciech
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Fetch-from-refcursor-and-transactions-tp5097158p5097158.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.