Re: DIAG [HY000] server closed the connection unexpectedly - Mailing list pgsql-odbc

Hi, Jon, Inoue-san,

Inoue-san,
The attached patch is rebased on HEAD.


Jon,

From: Jon Raiford [mailto:Raiford@labware.com]
> Yes, I can see that the code does answer 08S01, however it is being reported
> as 08001 to the application.  This can be seen even in the ODBC trace.  I'm
> not sure why it is changed.  Maybe this is a symptom of a bigger problem?

Didn't the 08001 get returned after you failed to reconnect?  As follows, I got 08S01 when I killed backend while it
wasrunning an SQL statement (e.g. SELECT pg_sleep(1000)). 

[isql command of unixODBC]
$ isql -v postgres
...
SQL> select pg_sleep(1000);
[ISQL]ERROR: Could not SQLExecute
[08S01]server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
;
The connection has been lost
SQL>

[my test app using SQLExecDirect]
08S01: server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
;
The connection has been lost

Regards
Takayuki Tsunakawa