Re: Backends created by ODBC live forever ... - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Backends created by ODBC live forever ...
Date
Msg-id 18310.1047317013@sss.pgh.pa.us
Whole thread Raw
In response to Backends created by ODBC live forever ...  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
Hans-Jürgen Schönig <postgres@cybertec.at> writes:
> ... However, if Access crashes or if the dial-up connections goes down 
> the connection is not closed explicitly and the server side backend 
> stays alive forever - even if the Windows client is rebooted.

It should time out and exit after an hour or so, I'd expect.  It sounds
like the TCP_KEEPALIVE code on the server side is failing to detect loss
of connection.  What is the server-side platform, exactly?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL99 ARRAY support proposal
Next
From: "Merlin Moncure"
Date:
Subject: Re: [GENERAL] division by zero