Re: WIP: Deferrable unique constraints

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WIP: Deferrable unique constraints
Дата
Msg-id 16885.1248875234@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WIP: Deferrable unique constraints  (Dean Rasheed <dean.a.rasheed@googlemail.com>)
Список pgsql-hackers
Dean Rasheed <dean.a.rasheed@googlemail.com> writes:
> 2009/7/29 Tom Lane <tgl@sss.pgh.pa.us>:
>> � For non-unique indexes, it is not required that <function>aminsert</>
>> � do anything; it might for instance refuse to index NULLs.

> Doesn't this comment apply equally to unique indexes?

Hmm, I was thinking that a unique-capable index would have to index all
tuples.  But I guess if it's restricted to one index column (like hash)
it could omit nulls and still enforce uniqueness correctly.  I'll change
that comment.
        regards, tom lane


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