Re: row number -1 is out of range 0..-1 - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: row number -1 is out of range 0..-1
Date
Msg-id 20050628125844.GA23489@winnie.fuhr.org
Whole thread Raw
In response to row number -1 is out of range 0..-1  ("Bobi Ivanov" <bobi@exsisto.com>)
List pgsql-bugs
On Tue, Jun 28, 2005 at 03:11:03PM +0300, Bobi Ivanov wrote:
>
>     I get this message 'row number -1 is out of range 0..-1' sometimes.
> I say sometimes, because this happens unexpected when I submit absolutely
> correct query. Query succeeds, but it returns no resul although there should be.

The above error happens if a program calls PQgetvalue(), PQgetlength(),
or PQgetisnull() with a row number of -1 and if there were no rows
in the result.  Are you calling those libpq functions directly, or
are you using an interface that sits on top of libpq?  If the latter,
what interface and version are you using?  What version of PostgreSQL?
What does your code look like?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-bugs by date:

Previous
From: "Bobi Ivanov"
Date:
Subject: row number -1 is out of range 0..-1
Next
From: Szűcs Gábor
Date:
Subject: Select on pkey returned more than one row