Re: [GENERAL] inet and cidr type problems - Mailing list pgsql-general

From Bruce Momjian
Subject Re: [GENERAL] inet and cidr type problems
Date
Msg-id 199907070206.WAA29919@candle.pha.pa.us
Whole thread Raw
In response to inet and cidr type problems  (jim@reptiles.org (Jim Mercer))
Responses Re: [GENERAL] inet and cidr type problems
List pgsql-general
> i have been playing with the inet and cidr types, and i have noticed a couple
> problems, and would entertain suggestions as to how to fix them without
> necessarily breaking how other people might be using them.
>
> - a table with an element of type inet, will show "0.0.0.0/0" as "00/0"

This was fixed in 6.5.

> i suspect this can be fixed in src/backend/adt/network.c or some such.
>
> - when creating a table with either type inet or type cidr as a primary, unique
>    key, the elements "198.68.123.0/24" and "198.68.123.0/27" are considered
>    equal.

This has been addressed in 6.5 too.


--
  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, Pennsylvania 19026

pgsql-general by date:

Previous
From: Doo Suk Yang
Date:
Subject: Re: [GENERAL] crypt in RH 6.0
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] RE: [GENERAL] Transaction logging