From: Craig Brozefsky <craig@red-bean.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: issues with libpg interface
Date: 18 Jan 2001 11:01:37 -0500
Message-ID: <874rywkfxa.fsf@piracy.red-bean.com> (raw)
In-Reply-To: <22568.979782928@sss.pgh.pa.us>
References: <87itndwy8n.fsf@piracy.red-bean.com>
<22568.979782928@sss.pgh.pa.us>
Tom Lane <tgl@sss.pgh.pa.us> writes:
> > 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.
>
> They don't. I think you must have some kind of multithreading bug
> on the client side (whether it's in libpq or your code is hard to say).
> A quick look at libpq's source shows that it can only generate
> PGRES_TUPLES_OK after seeing a 'T' (row descriptor) message from the
> backend, and the backend will surely not send such a thing except for
> SELECT or FETCH.
This is what we expected, but I wasn't familiar enough with the
details of the backend protocol to know how significant these symptoms
were. We've put locks on each database connection, so there should be
only one query running on a connection at a time. We've been running
it a few hours on a loaded application without any issues, so I think
it's cleared up, but I'm not prepared to give it a clean slate for
another day or so.
On that note, what do I need to do to get UncommonSQL listed in the
postgres interfaces page on the website?
UncommonSQL, available at http://alpha.onshore.com/lisp-software, is
both a functional and object-oriented interface to relational
databases for Common Lisp. It includes support for PostgreSQL, as
well as Oracle. It presently works in CMUCL, but should be portable
to other runtimes.
--
Craig Brozefsky <craig@red-bean.com>
In the rich man's house there is nowhere to spit but in his face
-- Diogenes
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: craig@red-bean.com, tgl@sss.pgh.pa.us
Subject: Re: issues with libpg interface
In-Reply-To: <874rywkfxa.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