Thread: INET and CIDR comparisons

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.

-- 
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.

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...



- Don Baccus, Portland OR <dhogaza@pacifier.com> Nature photos, on-line guides, and other goodies at
http://donb.photo.net

On Tue, 1 Jun 1999, 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. 

This is definitely true.  E.g., we have an in-house database which records
internet address delegations wherein a.b.c.0/22 can be and often is the
parent of a.b.c.0/23.  They should definitely be recignized as unique
from each other.

> I am sending a patch in.

Groovy.  I'll be pestering the present developer of that database to
uniquify the index.  8^)

--
Todd Graham Lewis                        Postmaster, MindSpring Enterprises
tlewis@mindspring.net                                (800) 719-4664, x22804

"A pint of sweat will save a gallon of blood."          -- George S. Patton

> 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.

Thanks.  One more item I can remove from Open Items list.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 

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.