Re: pgsql: Teach contrib/amcheck to check the unique constraint violation

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pgsql: Teach contrib/amcheck to check the unique constraint violation
Дата
Msg-id ZT_7hyCRfhkAFI0b@momjian.us
обсуждение исходный текст
Ответ на Re: pgsql: Teach contrib/amcheck to check the unique constraint violation  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: pgsql: Teach contrib/amcheck to check the unique constraint violation  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-committers
On Mon, Oct 30, 2023 at 04:17:52PM +0900, Michael Paquier wrote:
> Hi Alexander,
> 
> On Fri, Oct 27, 2023 at 09:21:50PM +0000, Alexander Korotkov wrote:
> > Teach contrib/amcheck to check the unique constraint violation
> > 
> > Add the 'checkunique' argument to bt_index_check() and bt_index_parent_check().
> > When the flag is specified the procedures will check the unique constraint
> > violation for unique indexes.  Only one heap entry for all equal keys in
> > the index should be visible (including posting list entries).  Report an error
> > otherwise.
> > 
> > pg_amcheck called with the --checkunique option will do the same check for all
> > the indexes it checks.
> 
> koel is unhappy with the indentation done in this commit.  See the
> parts about verify_nbtree.c and pg_amcheck.c:
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=koel&dt=2023-10-30%2007%3A04%3A04

Thanks, ran pgindent fix commits de64268561 and 5ae2087202a.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.



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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: pgsql: Fill in more of ObjectProperty
Следующее
От: Bruce Momjian
Дата:
Сообщение: pgsql: pgindent run to fix commits de64268561 and 5ae2087202a