Re: cidr & inet types - Mailing list pgsql-general

From Tom Lane
Subject Re: cidr & inet types
Date
Msg-id 20262.1058678650@sss.pgh.pa.us
Whole thread Raw
In response to cidr & inet types  (Tim Conrad <conrad@external.timconrad.org>)
List 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 by date:

Previous
From: Tim Conrad
Date:
Subject: cidr & inet types
Next
From: Jason Godden
Date:
Subject: Re: Horrible pg_restore performance, please help