Re: [HACKERS] Open 6.5 items

From: "D'Arcy" "J(dot)M(dot)" Cain <darcy(at)druid(dot)net>
To: maillist(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian)
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Open 6.5 items
Date: 1999-05-24 16:51:20
Message-ID: m10lxwe-0000bIC@druid.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at){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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message D'Arcy J.M. Cain 1999-05-24 16:55:47 Re: [HACKERS] Updated 6.5 HISTORY
Previous Message Keith Parks 1999-05-24 16:11:01 Problem in S_LOCK?