Skip site navigation (1) Skip section navigation (2)

Re: right sibling is not next child

From: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: right sibling is not next child
Date: 2006-04-12 15:50:04
Message-ID: 443CDB5C020000BE00002C98@gwmta.wicourts.gov (view raw or flat)
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)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


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-04-12 16:03:12
Subject: Re: right sibling is not next child
Previous:From: Tom LaneDate: 2006-04-12 15:29:39
Subject: Re: right sibling is not next child

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group