pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedsome libpq interface issues
2+ messages / 2 participants
[nested] [flat]
* some libpq interface issues
@ 2001-01-17 22:59 Nesta Stubbs <nesta@red-bean.com>
0 siblings, 1 reply; 2+ messages in thread
From: Nesta Stubbs @ 2001-01-17 22:59 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: some libpq interface issues
@ 2001-01-18 18:24 Craig Brozefsky <craig@red-bean.com>
parent: Nesta Stubbs <nesta@red-bean.com>
0 siblings, 0 replies; 2+ messages in thread
From: Craig Brozefsky @ 2001-01-18 18:24 UTC (permalink / raw)
To: Nesta Stubbs <nesta@red-bean.com>; +Cc: pgsql-interfaces
Nesta Stubbs <nesta@red-bean.com> writes:
> 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.
Uhg, sorry for the repeats. I had some gnus lossage that wiped out my
per group From hacks and I didn't notice it until too late.
--
Craig Brozefsky <craig@red-bean.com>
In the rich man's house there is nowhere to spit but in his face
-- Diogenes
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-01-18 18:24 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-01-17 22:59 some libpq interface issues Nesta Stubbs <nesta@red-bean.com>
2001-01-18 18:24 ` Craig Brozefsky <craig@red-bean.com>
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