On Tue, Jun 28, 2005 at 03:11:03PM +0300, Bobi Ivanov wrote:
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/

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

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 (AT) fuhr (DOT) org>
To: "Bobi Ivanov" <bobi (AT) exsisto (DOT) com>
Cc: <pgsql-bugs (AT) postgresql (DOT) org>
Sent: Tuesday, June 28, 2005 3:58 PM
Subject: Re: [BUGS] row number -1 is out of range 0..-1



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

On Tue, Jun 28, 2005 at 04:07:33PM +0300, Bobi Ivanov wrote:
How consistently do you get the error? What happens if you run the
query in psql?

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

"Bobi Ivanov" <bobi (AT) exsisto (DOT) com> writes:
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

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Tom Lane wrote:
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

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)