Re: Comments on Exclusion Constraints and related datatypes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Comments on Exclusion Constraints and related datatypes
Дата
Msg-id 201006030147.o531lhD13152@momjian.us
обсуждение исходный текст
Ответ на Re: Comments on Exclusion Constraints and related datatypes  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas wrote:
> > * inet datatypes don't have a commutative operator on which a unique
> > index can be built. There is no "overlaps" equivalent, which again is a
> > shame because that stops them being used with the new feature.
> 
> This would be a nice thing to fix, and I was thinking about doing it,
> but I just ran out of time.  I think it can be left for 9.1.  I have
> not infrequently wanted to build an IP allocation database, and this
> would be perfect for that.

Added to TODO:
Add INET overlaps operator, for use by exclusion constraints    *
http://archives.postgresql.org/pgsql-hackers/2010-03/msg00845.php
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + None of us is going to be here forever. +


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Comments on Exclusion Constraints and related datatypes
Следующее
От: Florian Pflug
Дата:
Сообщение: Re: recovery getting interrupted is not so unusual as it used to be