Re: PQgetvalue: ERROR! tuple number 0 is out of range 0..-1

From: Jim Mercer <jim(at)reptiles(dot)org>
To: mlw <markw(at)mohawksoft(dot)com>
Cc: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Date: 2001-06-07 12:39:47
Message-ID: 20010607083947.E10741@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jun 07, 2001 at 08:36:48AM -0400, mlw wrote:
> I get this a lot and it keeps me from backing up the database.
>
> This database is still 7.0.3. Anyone knows what cases it and how to correct
> it, because I can't dump to a new database.

is this coming from one of your applications?
"PQgetvalue: ERROR! tuple number 0 is out of range 0..-1"

if so, the it is possible that the application is doing a select, which
returns 0 rows.

and your application is attempting to access the value of a non-existant row.

--
[ Jim Mercer jim(at)reptiles(dot)org +1 416 410-5633 ]
[ Now with more and longer words for your reading enjoyment. ]

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Ivar Helbekkmo 2001-06-07 12:46:50 Re: AW: AW: Re: [SQL] behavior of ' = NULL' vs. MySQL vs. S tand ards
Previous Message mlw 2001-06-07 12:36:48 PQgetvalue: ERROR! tuple number 0 is out of range 0..-1