Re: [SQL] Duplicate tuples with unique index

Поиск
Список
Период
Сортировка
От Patrik Kudo
Тема Re: [SQL] Duplicate tuples with unique index
Дата
Msg-id 388C22D9.A66DB9C1@partitur.se
обсуждение исходный текст
Ответ на Duplicate tuples with unique index  (Patrik Kudo <kudo@partitur.se>)
Список 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 по дате отправления:

Предыдущее
От: Mercury He
Дата:
Сообщение: Question about COPY command
Следующее
От: "Neil Cameron"
Дата:
Сообщение: Blobs