status of CURSORs after DISCONNECT - Mailing list pgsql-general

From Matthias Apitz
Subject status of CURSORs after DISCONNECT
Date
Msg-id 20191128062715.GA2642@c720-r342378
Whole thread Raw
Responses Re: status of CURSORs after DISCONNECT
List pgsql-general
Hello,

When an ESQL/C written process issues a

EXEC SQL DISCONNECT [connection];

do the opened CURSOR(s) still survive? We run into the problem that the
father process issues DISCONNECT before forking children, the forked child
CONNECTs to the same server and database again and "thinks" it has to CLOSE the
CURSOR (perhaps a long standing bug in our application we port now from
Sybase(...) to PostgreSQL).

Thanks

    matthias
-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub

"Glaube wenig, hinterfrage alles, denke selbst: Wie man Manipulationen durchschaut"
"Believe little, scrutinise all, think by your own: How see through manipulations"
ISBN-10: 386489218X



pgsql-general by date:

Previous
From: Lauri Kajan
Date:
Subject: Re: Range contains element filter not using index of the element column
Next
From: Alban Hertroys
Date:
Subject: Re: Range contains element filter not using index of the elementcolumn