Re: [SQL] Duplicate tuples with unique index

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-sql(at)postgreSQL(dot)org" <pgsql-sql(at)postgresql(dot)org>, girgen(at)partitur(dot)se
Subject: Re: [SQL] Duplicate tuples with unique index
Date: 2000-01-24 10:00:57
Message-ID: 388C22D9.A66DB9C1@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2000-01-24 10:48:57 Re: [SQL] Question about COPY command
Previous Message Mercury He 2000-01-24 04:11:19 Question about COPY command