Re: Connection of postgres

i open connection, and leave it for few hour, and then excute query, and
ge=
t error.

________________________________

From: pgsql-odbc-owner@[EMAIL PROTECTED]
 on behalf of Adam M
Sent: Wed 4/9/2008 2:40 PM
Cc: pgsql-odbc@[EMAIL PROTECTED]
 Re: [ODBC] Connection of postgres



I've had a similar "problem". The connection times out and get closed
after a few hours. The solution was to do a query to keep the database
alive, for example "SELECT 1" and that's all. That is done every few
minutes.

The real test is to open 250 connections, and issue queries on each
without idle time. Does connection drop occur on active connections?

--
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc



This email may contain material that is confidential, privileged, and/or
at=
torney work product for the sole use of the intended recipient.  Any
review=
, reliance, or distribution by others or forwarding without express
permiss=
ion is strictly prohibited.  If you are not the intended recipient, please
=
contact the sender and delete all copies.

--=20
Sent via pgsql-odbc mailing list (pgsql-odbc@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc