Re: UNIQUE null treatment option

Поиск
Список
Период
Сортировка
От Pavel Borisov
Тема Re: UNIQUE null treatment option
Дата
Msg-id CALT9ZEGAi4Sn_qvCVrdYAtZA=9uwAOXv2ft9R-iBJ2abRS7uew@mail.gmail.com
обсуждение исходный текст
Ответ на Re: UNIQUE null treatment option  (Peter Geoghegan <pg@bowt.ie>)
Список pgsql-hackers
I wonder if the logic for setting BTScanInsertData.anynullkeys inside
_bt_mkscankey() is the place to put your test for
rel->rd_index->indnullsnotdistinct -- not inside _bt_doinsert(). That
would probably necessitate renaming anynullkeys, but that's okay. This
feels more natural to me because a NULL key column in a NULLS NOT
DISTINCT unique constraint is very similar to a NULL non-key column in
an INCLUDE index, as far as our requirements go -- and so both cases
should probably be dealt with at the same point.

A good point, indeed!

--
Best regards,
Pavel Borisov

Postgres Professional: http://postgrespro.com

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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Adding CI to our tree
Следующее
От: Justin Pryzby
Дата:
Сообщение: Re: Adding CI to our tree