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 по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: dependencies for generated header files
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Review: Revise parallel pg_restore's scheduling heuristic