Received: from thoth.cymitar.com (thoth.cymitar.com [207.71.45.136]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA22149 for ; Thu, 13 Aug 1998 11:57:02 -0400 (EDT) Received: (from delmendo@localhost) by thoth.cymitar.com (8.8.5/8.8.5) id KAA19439 for pgsql-interfaces@postgresql.org; Thu, 13 Aug 1998 10:57:39 -0500 Message-ID: X-Mailer: XFMail 1.3 [p0] on Linux X-Priority: 3 (Normal) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit MIME-Version: 1.0 Date: Thu, 13 Aug 1998 10:57:39 -0500 (CDT) Reply-To: delmendo@cymitar.net Organization: Cymitar Technology Group Inc. Sender: delmendo@thoth.cymitar.com From: Dirk Elmendorf To: pgsql-interfaces@postgresql.org Subject: Libpq problems I have a program which opens two connections to two different databases. After issuing a few commands to the second database I this get in the trace log: To backend> QSELECT oid FROM order_table WHERE customer_number=936 ; From backend> N From backend> "NOTICE: SIMarkEntryData: cache state reset Then I get a SIGPIPE on the first database which courrpts my connection. The funny thing i s that PQstatus still says I have a good connection.The second database continues plugging along. I cannot seem to figure out how to stop this - if I re-issuse all the SQL in psql each command works like a charm - but when I do it through libpq I can not seem to escape the problem - Has anyone else run into this problem? Can anyone explain what this Notice means? I searched through the Mailing lists and found a number of emails asking the same quesiton- but no answer could be found. Any insight would be greatly appreciated. I'm running 6.3.2 on RH 4.2 I tried opening the first db grabbing some info and then closing the connection- then I op en the second databse- I'm still able to generate this error. _________________________________________________________ Dirk Elmendorf, VP/Development Main: 210-892-4000 Cymitar Technology Group, Inc. Direct: 210-892-4005 Lorene Office Plaza Fax: 210-892-4329 9828 Lorene Lane San Antonio, TX 78216-4450 _________________________________________________________