Re: [HACKERS] INET and CIDR comparisons - Mailing list pgsql-hackers

From D'Arcy" "J.M." Cain
Subject Re: [HACKERS] INET and CIDR comparisons
Date
Msg-id m10pJLF-0000bIC@druid.net
Whole thread Raw
In response to Re: [HACKERS] INET and CIDR comparisons  (Don Baccus <dhogaza@pacifier.com>)
List pgsql-hackers
Thus spake Don Baccus
> At 09:30 PM 6/1/99 -0400, D'Arcy" "J.M." Cain wrote:
> >I heard back from Paul Vixie and he says that it should be possible to
> >store two values in a unique index if they differ only in netbits.  I
> >am sending a patch in.
> 
> I've stayed out of this discussion, but Paul makes a lot of
> sense.  They're NOT the same networks...

Agreed.  My only point was that using the fields was probably a bad
idea anyway and, if you did, allowing both then made even less sense
but that's more of design issue.

In any case, if someone wants the protection, they can always add a unique
index on host(field).

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] current CVS snapshot of pgsql crash ...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re:ORDER BY