Re: System Log is logging row number -1 is out of range 0..-1 - Mailing list pgsql-general

From Tom Lane
Subject Re: System Log is logging row number -1 is out of range 0..-1
Date
Msg-id 22984.1266556649@sss.pgh.pa.us
Whole thread Raw
In response to System Log is logging row number -1 is out of range 0..-1  (Naoko Reeves <naokoreeves@gmail.com>)
List pgsql-general
Naoko Reeves <naokoreeves@gmail.com> writes:
> We are using custom plugin to connect to postgresql.
> We reviewed OS (OS X 10.6.2 2.26 GHz Quad-Core Intel Xeon Meomory 6
> GB) system log and noticed that the following lines are repeated in
> the log all day...(This log records NOTICE from sql as well)

> Feb 17 20:43:25 LLX-4DA-2 [0x0-0xfd8fd8].com.4d.4d[73523]: row number
> -1 is out of range 0..-1

This is libpq bleating about an attempt to access a nonexistent row in
an empty PGresult result set.  Evidently there's a bug in some level of
your client-side code that is causing it to not notice that it got an
empty result set.

            regards, tom lane

pgsql-general by date:

Previous
From: Naoko Reeves
Date:
Subject: System Log is logging row number -1 is out of range 0..-1
Next
From: Yan Cheng Cheok
Date:
Subject: Getting number of affected row after performing update