Re: cidr & inet types

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: cidr & inet types
Дата
Msg-id 20262.1058678650@sss.pgh.pa.us
обсуждение исходный текст
Ответ на cidr & inet types  (Tim Conrad <conrad@external.timconrad.org>)
Список pgsql-general
Tim Conrad <conrad@external.timconrad.org> writes:
> While it's possible it's just my viewpoint, it seems that this is kind of weird
> behavior. If the datatype has any notion of networks and that data being
> 'unique' shouldn't it also know about netmasks?

A UNIQUE constraint means there are no two entries in the column that
are *equal*.  I understand what you're after, but I don't really see why
you'd expect a UNIQUE constraint to do it for you.

            regards, tom lane

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

Предыдущее
От: Tim Conrad
Дата:
Сообщение: cidr & inet types
Следующее
От: Jason Godden
Дата:
Сообщение: Re: Horrible pg_restore performance, please help