Re: [SQL] Duplicate tuples with unique index

Tom Lane wrote:
>
> Patrik Kudo <kudo(at)partitur(dot)se> writes:
> > db=> vacuum ;
> > NOTICE: Rel pg_statistic: TID 1/93: OID IS INVALID. TUPGONE 0.
> > NOTICE: Index html_text_idx: NUMBER OF INDEX' TUPLES (1193) IS NOT THE
> > SAME AS HEAP' (1258)
> > ERROR: Cannot insert a duplicate key into a unique index
>
> Given the reference to pg_statistic, I wonder if you aren't getting
> burnt by the recently-discovered bug wherein VACUUM ANALYZE tries to
> create pg_statistic tuples that are too long. I recommend (a) patch
> vacuum.c (see Dirk Lutzebaeck's nearby message); then (b) drop and
> recreate html_text_idx; finally (c) DELETE FROM pg_statistic and
> then VACUUM ANALYZE to rebuild it. Good luck!
>
> regards, tom lane
>
> ************
Unfotunately, it doesn't quite work:

pp=> vacuum analyze;
NOTICE: Rel pg_statistic: TID 1/93: OID IS INVALID. TUPGONE 0.
VACUUM
pp=> delete from pg_statistic;
ERROR: heap_delete: (am)invalid tid
pp=>