From: Nesta Stubbs <nesta@red-bean.com>
To: pgsql-interfaces@postgresql.org
Subject: some libpq interface issues
Date: 17 Jan 2001 17:59:22 -0500
Message-ID: <871yu1yed1.fsf@piracy.red-bean.com> (raw)
We have two situations that have arisen while using libpq thru CMUCL
bindings in our UncommonSQL package. We have a multi-processing
application which uses a pool of database connections to perform DB
queries.
The first one is that we are getting unexpected retun values from
pgresultstatus after calling pgexec, a value of PGRES_TUPLES_OK. The
thing is that we're not sending a SELECT, just UPDATES, INSERTS and
DELETES. My understanding is that none of those return tuples.
Here is the message our interface spits out.
;; Warning, database-execute-command: Recieved tuples ok in response
to UPDATE WCO_ALLOCATION SET CANCELLED_TIME = '2001-01-12
16:50:10+00',DELETED_AGENT_ID = 0,PICKUP = 'f',RETURN_AGENT_ID =
7104,NON_EXPIRING = 'f',INSTRUCTIONS = '',BUILDING_PASSES =
'NIL',ACCOMPANYING_PEOPLE = 'NIL',PICKUP_PEOPLE = 'NIL',COMMENTS =
'',CREATED_TIME = '2001-01-12 16:50:50+00',REPEAT_RULE =
'NIL',END_TIME = '2001-01-16 17:48:00+00',START_TIME = '2001-01-12
16:50:50+00',AGENT_ID = 6761,CUSTOMER_ID = 3970,LOCATION_ID =
4,ALLOCATION_TYPE = 'COMPLETED-CHECKOUT',ALLOCATION_ID = 34166
WHERE WCO_ALLOCATION.ALLOCATION_ID = 34166
So, is it possible for an UPDATE to correctly return PGRES_TUPLES_OK,
or are we seeing some confusion in the backend or libpq due to load
and multi-processing?
Also, unrelated, I think, to the above issue, we are getting the
following message intermittently:
Backend message type 0x50 arrived while idle
I cannot find any more information about this message in the
documentation, so I don't know what type of message that is.
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: nesta@red-bean.com
Subject: Re: some libpq interface issues
In-Reply-To: <871yu1yed1.fsf@piracy.red-bean.com>
* 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