X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9ABD59DCA8D for ; Wed, 14 Dec 2005 20:51:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36129-06-5 for ; Wed, 14 Dec 2005 20:51:06 -0400 (AST) X-Greylist: delayed 01:58:51.256517 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by postgresql.org (Postfix) with ESMTP id E31B49DCAD3 for ; Wed, 14 Dec 2005 20:50:54 -0400 (AST) Received: from mail.cognitronics.com (mail.cognitronics.com [198.151.128.252]) by svr2.postgresql.org (Postfix) with ESMTP id 33F1AF0B04 for ; Wed, 14 Dec 2005 22:52:06 +0000 (GMT) Received: from [127.0.0.1] ([10.1.0.46]) by mail.cognitronics.com (8.13.0/8.13.0) with ESMTP id jBEMpfeO068884 for ; Wed, 14 Dec 2005 17:51:43 -0500 (EST) Message-ID: <43A0A212.2070202@cognitronics.com> Date: Wed, 14 Dec 2005 17:52:02 -0500 From: Kashyap Jani User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-interfaces@postgresql.org Subject: Dropped conection from libpq PGconn Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/20 X-Sequence-Number: 5888 Hi All, I was wondering why does PGconn object keeps saying the connection is OK if I lost my Ethernet connection to the box where my database is running ? If that's the case does any one know how to check if my connection objects are not valid anymore without using PGReset function call. I will really appreciate any help any one can provide. Regards, Kashyap Jani