Re: [SQL] Duplicate tuples with unique index - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: [SQL] Duplicate tuples with unique index
Date
Msg-id 388C22D9.A66DB9C1@partitur.se
Whole thread Raw
In response to Duplicate tuples with unique index  (Patrik Kudo <kudo@partitur.se>)
List pgsql-sql
Thanks!

We'll try it out.

Regards,
Patrik Kudo

Tom Lane wrote:
> 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


pgsql-sql by date:

Previous
From: Mercury He
Date:
Subject: Question about COPY command
Next
From: "Neil Cameron"
Date:
Subject: Blobs