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

Hi, Jon, Inoue-san

From: pgsql-odbc-owner@postgresql.org
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Jon Raiford
> Here is an excerpt from my ODBC tracing on Windows.  You can see that the
> error is being reported as 08001 instead of 08S01:
> v               a14-135c        EXIT  SQLEndTran  with return code -1
> (SQL_ERROR)
>                 SQLSMALLINT                  2 <SQL_HANDLE_DBC>
>                 SQLHANDLE           0x0026CCC8
>                 SQLSMALLINT                  0
>
>                 DIAG [08001] server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
>  (101)

Thanks, Jon.  08001 was set when the driver failed to send the query (COMMIT in this case.)

Inoue-san, the attached is a revised patch.  I changed the error code to CONNECTION_COMMUNICATION_ERROR when
PQsendQuery()fails. 

Regards
Takayuki Tsunakawa