pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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>
_________________________________________________________





Message-ID: <XFMail.980813105739.delmendo@cymitar.net>
Permalink:  ../XFMail.980813105739.delmendo@cymitar.net/
Also on:    postgresql.org/message-id/XFMail.980813105739.delmendo@cymitar.net

 · 

reply

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