Re: SELECT returning too many rows (?)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: robf <rob(at)dsvr(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: SELECT returning too many rows (?)
Date: 2005-02-08 17:04:10
Message-ID: 7396.1107882250@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

robf <rob(at)dsvr(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Joe Brown 2005-02-08 19:42:14 Re: BUG #1466: #maintenace_work_mem = 16384
Previous Message robf 2005-02-08 16:41:51 Re: SELECT returning too many rows (?)