Re: Backends created by ODBC live forever ...

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: hs(at)cybertec(dot)at
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Backends created by ODBC live forever ...
Date: 2003-03-10 17:23:33
Message-ID: 18310.1047317013@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres(at)cybertec(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Merlin Moncure 2003-03-10 18:19:19 Re: [GENERAL] division by zero
Previous Message Tom Lane 2003-03-10 17:20:26 Re: SQL99 ARRAY support proposal