Re: SELECT returning too many rows (?) - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SELECT returning too many rows (?)
Date
Msg-id 7396.1107882250@sss.pgh.pa.us
Whole thread Raw
In response to Re: SELECT returning too many rows (?)  (robf <rob@dsvr.net>)
Responses Re: SELECT returning too many rows (?)  (rob <rob@dsvr.net>)
List pgsql-bugs
robf <rob@dsvr.net> writes:
> Can I now remove these two errant records or do you think there is
> anything to gain from continuing with this investigation ?

If you have the time, it would be interesting to dump out the rows with
pg_filedump (see http://sources.redhat.com/rhdb/).  I usually use
"pg_filedump -i -f" to get the most useful display.  Looks like you need
to dump pages 3, 5, and 7 of that table to see all three rows.

            regards, tom lane

pgsql-bugs by date:

Previous
From: robf
Date:
Subject: Re: SELECT returning too many rows (?)
Next
From: Tom Lane
Date:
Subject: Re: BUG #1466: #maintenace_work_mem = 16384