Skip site navigation (1) Skip section navigation (2)

Getting results after networking error

From: jtv(at)xs4all(dot)nl
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Getting results after networking error
Date: 2005-08-09 15:16:44
Message-ID: 4395.210.86.147.191.1123600604.squirrel@210.86.147.191 (view raw or flat)
Thread:
Lists: pgsql-interfaces
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



Responses

pgsql-interfaces by date

Next:From: DavidDate: 2005-08-09 16:10:24
Subject: Re: pgperl vs dbd-perl
Previous:From: Sean DavisDate: 2005-08-09 14:57:41
Subject: Re: pgperl vs dbd-perl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group