Postgres Pro
Downloads
Home   >   mailing lists

[INTERFACES] Questions on Cursors in PostgreSQL - Mailing list pgsql-interfaces

From Wei Shan
Subject [INTERFACES] Questions on Cursors in PostgreSQL
Date
Msg-id CAFe9ZTov6QotwvyAmd_ibyXi=KYQpvLNgcCCV-0ZaLeZUjaqPw@mail.gmail.com
Whole thread Raw
Responses Re: [INTERFACES] Questions on Cursors in PostgreSQL  (Dmitry Igrishin <dmitigr@gmail.com>)
List pgsql-interfaces
Tree view
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

pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] PostgreSQL, and ODBC statement handles
Next
From: Dmitry Igrishin
Date:
Subject: Re: [INTERFACES] Questions on Cursors in PostgreSQL