Re: [HACKERS] Open 6.5 items - Mailing list pgsql-hackers

From D'Arcy" "J.M." Cain
Subject Re: [HACKERS] Open 6.5 items
Date
Msg-id m10lxwe-0000bIC@druid.net
Whole thread Raw
In response to Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Thus spake Bruce Momjian
> Table with an element of type inet, will show "0.0.0.0/0" as "00/0"

Is that an error?  From the discussions with Paul Vixie, I think that
that is the correct way to output it.  Note that you can always use
host() to get the full string for the host part at least.

> When creating a table with either type inet or type cidr as a primary,unique
>    key, the "198.68.123.0/24" and "198.68.123.0/27" are considered equal

I guess I'll take a stab at it.  I just need to know which of the following
is true.
   198.68.123.0/24 < 198.68.123.0/27   198.68.123.0/24 > 198.68.123.0/27

Also, is it possible that the current behaviour is what we want?  It seems
to me that if you make a network a primary key, you probably want to prevent
overlap.  What we have does that.


> add ability to add comments to system tables using table/colname combination

Why not just add comments to pg_description?


-- 
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: Oleg Bartunov
Date:
Subject: Re: [HACKERS] Updated 6.5 HISTORY
Next
From: "D'Arcy" "J.M." Cain
Date:
Subject: Re: [HACKERS] Updated 6.5 HISTORY