From: Dirk Elmendorf <delmendo@cymitar.net>
To: pgsql-interfaces@postgresql.org
Subject: Libpq problems
Date: Thu, 13 Aug 1998 10:57:39 -0500 (CDT)
Message-ID: <XFMail.980813105739.delmendo@cymitar.net> (raw)
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 <http://www.cymitar.com;
San Antonio, TX 78216-4450 <delmendo@cymitar.com>
_________________________________________________________
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: delmendo@cymitar.net
Subject: Re: Libpq problems
In-Reply-To: <XFMail.980813105739.delmendo@cymitar.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox