BUG #18002: Duplicate entries of row possible even after having primary key

Поиск
Список
Период
Сортировка
От PG Bug reporting form
Тема BUG #18002: Duplicate entries of row possible even after having primary key
Дата
Msg-id 18002-00f2b6cb2b9c0b02@postgresql.org
обсуждение исходный текст
Ответы Re: BUG #18002: Duplicate entries of row possible even after having primary key  (Andres Freund <andres@anarazel.de>)
Re: BUG #18002: Duplicate entries of row possible even after having primary key  (David Rowley <dgrowleyml@gmail.com>)
Список pgsql-bugs
Дерево обсуждения 
The following bug has been logged on the website:

Bug reference:      18002
Logged by:          Ajinkya Tankhiwale
Email address:      ajinkya.tankhiwale@tcs.com
PostgreSQL version: 14.7
Operating system:   RHEL 8.8
Description:

We migrated from 13.7 to 14.7 recently, in current data setup, we say that
duplicate records are present in table even after primary key. I see that in
the past, same issue was reported and possible solution was to run full
vacuum or re-index. We tried both, but still able to enter duplicate
records. 

This is blocker for us and would like to have solution for this as soon as
possible.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Alexander Lakhin
Дата:
Сообщение: Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index
Следующее
От: Nathan Bossart
Дата:
Сообщение: Re: BUG #18000: Access method used by matview can be dropped leaving broken matview