Hi all,
I have some questions on PostgreSQL cursors (not PL/pgSQL but the libpq
implementation):
1. What happens when my cursor hit the end of the table? Does it close
automatically? I suppose if I declare it as a SCROLLABLE cursor, it should
not close at all.
2. If I have declared a cursor and the session got disconnected, can I
reattach back to the cursor if I know the cursor name? I believe this is
not possible but I'm not very sure.
Thanks!
--
Regards,
Ang Wei Shan