Message-ID: <4395.210.86.147.191.1123600604.squirrel@210.86.147.191>
Date: Tue, 9 Aug 2005 17:16:44 +0200 (CEST)
Subject: Getting results after networking error
From: jtv@xs4all.nl
To: pgsql-interfaces@postgresql.org
User-Agent: SquirrelMail/1.4.3a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi all,

Here's something I've been trying to figure out about libpq, and I hope
perhaps someone here can shed some light on it.

I sometimes issue multiple queries at once using semicolons, so one call
returns multiple results.  Now let's say my network connection to the
backend breaks and not all the results can be returned--I get a result
with some error code (wish I knew which, but that's another story)
followed by a NULL result to indicate that no more results are following,
right?

Now let's say that I issue my next query and the network connection
recovers in the process.  I happily start retrieving results again, but
are they only results for the new query, or do I go through the remaining
results of the last query first?


Jeroen