Re: UNIQUE null treatment option - Mailing list pgsql-hackers

From Pavel Borisov
Subject Re: UNIQUE null treatment option
Date
Msg-id CALT9ZEGAi4Sn_qvCVrdYAtZA=9uwAOXv2ft9R-iBJ2abRS7uew@mail.gmail.com
Whole thread Raw
In response to Re: UNIQUE null treatment option  (Peter Geoghegan <pg@bowt.ie>)
List 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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Adding CI to our tree
Next
From: Justin Pryzby
Date:
Subject: Re: Adding CI to our tree