[HACKERS] Backends created by ODBC live forever ...

2003-03-10 Thread Hans-Jürgen Schönig
We have an application which syncs Access databases with PostgreSQL (I know that this is VERY ugly). It is a simple script based Access application. People wanted that application because they are familiar with Microsoft stuff. When Access establishes a connection to PostgreSQL everything is

Re: [HACKERS] Backends created by ODBC live forever ...

2003-03-10 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= [EMAIL PROTECTED] 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

Re: [HACKERS] Backends created by ODBC live forever ...

2003-03-10 Thread Tom Lane
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= [EMAIL PROTECTED] writes: As far as I have seen it did not time out - at least it seems that it doesn't. Also, if we were running a system with many unreliable clients we'd run out of memory soon. It is also a potential security problem. I do not see