| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Naoko Reeves <naokoreeves(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: System Log is logging row number -1 is out of range 0..-1 |
| Date: | 2010-02-19 05:17:29 |
| Message-ID: | 22984.1266556649@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Naoko Reeves <naokoreeves(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Yan Cheng Cheok | 2010-02-19 05:42:18 | Getting number of affected row after performing update |
| Previous Message | Naoko Reeves | 2010-02-19 05:09:42 | System Log is logging row number -1 is out of range 0..-1 |