Re: right sibling is not next child - Mailing list pgsql-bugs

I can't find any duplicates?!?

The query

select starelid, staattnum, ctid, xmin, xmax, cmin, cmax
from pg_statistic p1
where (select count(*) from pg_statistic p2 where
  p1.starelid = p2.starelid and p1.staattnum = p2.staattnum) > 1

doesn't turn up anything.  Nor does dumping

select starelid, staattnum from pg_statistic

to a file and using sort | uniq -c

Pete

>>> Tom Lane <tgl@sss.pgh.pa.us> 04/12/06 4:37 pm >>>
Hm, can you see any rows in pg_statistic with duplicate values of
(starelid, staattnum)?  If so it'd be useful to look at their
ctid/xmin/xmax/cmin/cmax values.

            regards, tom lane