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

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 a

[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 ju