Postgres Pro
Downloads
Home   >   mailing lists

Re: status of CURSORs after DISCONNECT - Mailing list pgsql-general

From Tom Lane
Subject Re: status of CURSORs after DISCONNECT
Date
Msg-id 31445.1574953130@sss.pgh.pa.us
Whole thread Raw
In response to status of CURSORs after DISCONNECT  (Matthias Apitz <guru@unixarea.de>)
List pgsql-general
Tree view 
Matthias Apitz <guru@unixarea.de> writes:
> When an ESQL/C written process issues a
> EXEC SQL DISCONNECT [connection];
> do the opened CURSOR(s) still survive?

No.  Cursors are purely session-local objects in Postgres.
I'm a bit surprised to hear it might be different in Sybase.

            regards, tom lane

pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Re: Postgres Full Text Search Jsonb Array column does notsearch for first row
Next
From: George Neuner
Date:
Subject: Re: status of CURSORs after DISCONNECT