MIME-Version: 1.0
From: Sayan Oruspay <sayanoruspai@gmail.com>
Date: Tue, 20 Jun 2023 15:38:32 +0700
Message-ID: 
 <CANdk+b+eSm05tBKLFLXFa4j+CxC6+_XtyZfu5t2tqjpeDXB4Lw@mail.gmail.com>
Subject: BUG #17981: HY000 server closed the connection unexpectedly
To: pgsql-odbc@postgresql.org
Content-Type: multipart/alternative; boundary="00000000000025f14805fe8b94c0"
Archived-At: 
 <https://www.postgresql.org/message-id/CANdk%2Bb%2BeSm05tBKLFLXFa4j%2BCxC6%2B_XtyZfu5t2tqjpeDXB4Lw%40mail.gmail.com>
Precedence: bulk

--00000000000025f14805fe8b94c0
Content-Type: text/plain; charset="UTF-8"

I am writing an application on Windows that connects to the local database
through psqlodbc. I want to make it automatically detect connection loss
and reconnect. When I manually stop the database service and try to send a
query, I get an error with sqlstate HY000 and the message ' server closed
the connection unexpectedly'. Shouldn't sqlstate be something like 08S01?
Also  SQLGetConnectAttr with SQL_ATTR_CONNECTION_DEAD does not produce the
right value. The value it returns is always SQL_CD_FALSE.

--00000000000025f14805fe8b94c0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I am writing an application on Windows that connects to th=
e local database through psqlodbc. I want to make it automatically detect c=
onnection loss and reconnect. When I manually stop the database service and=
 try to send a query, I get an error with sqlstate HY000 and the message &#=
39;

<span style=3D"color:rgb(80,0,80)">server closed the connection unexpectedl=
y&#39;. Shouldn&#39;t sqlstate be something like 08S01? Also=C2=A0</span>

SQLGetConnectAttr with SQL_ATTR_CONNECTION_DEAD does not produce the right =
value. The value it returns is always SQL_CD_FALSE.</div>

--00000000000025f14805fe8b94c0--