row number -1 is out of range 0..-1

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/

Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under
Fedora Core and I'm writing queries through pgAdminIII. This is the query
that produces it:

select
billingplans_freetalktime.id, billingplans_freetalktime.seconds,
billingplans_freetalktime.accumulate, billingplans_freetalktime.period
from (billingplans_freetalktime inner join tariffs
on billingplans_freetalktime.tariff_id = tariffs.id_tariff)
where billingplans_freetalktime.plan_id = 5
and '3597' like tariffs.prefix||'%'
order by length(tariffs.prefix) desc;

and I get this:

row number -1 is out of range 0..-1
Total query runtime: 40 ms.
Data retrieval runtime: 60 ms.
0 rows retrieved.

I'll be glad if you can tell me how can I fix it. Do you know patch or
something?

-Bobi Ivanov

----- Original Message -----
From: "Michael Fuhr" <mike@fuhr.org>
To: "Bobi Ivanov" <bobi@exsisto.com>
Cc: <pgsql-bugs@postgresql.org>
Sent: Tuesday, June 28, 2005 3:58 PM
Subject: Re: [BUGS] row number -1 is out of range 0..-1

On Tue, Jun 28, 2005 at 04:07:33PM +0300, Bobi Ivanov wrote:

Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under Fedora Core and I'm writing queries through pgAdminIII.

How consistently do you get the error? What happens if you run the
query in psql?

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

"Bobi Ivanov" <bobi@exsisto.com> writes:

Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under
Fedora Core and I'm writing queries through pgAdminIII.

I would say then that this is a pgAdmin bug, and should be reported on
the pgAdmin mailing lists --- I'm not sure that any of the pgAdmin
hackers read this list.

regards, tom lane

Tom Lane wrote:

"Bobi Ivanov" <bobi@exsisto.com> writes:

Thank you for your quick responce! I don't call them directly. I use pgsql
8.0.3 under
Fedora Core and I'm writing queries through pgAdminIII.

I would say then that this is a pgAdmin bug, and should be reported on
the pgAdmin mailing lists --- I'm not sure that any of the pgAdmin
hackers read this list.

I do read the list, though I missed it initially.
I doubt it's a pgadmin bug, but let's see the query first.

Regards,
Andreas