Re: [HACKERS] Open 6.5 items

Поиск
Список
Период
Сортировка
От D'Arcy" "J.M." Cain
Тема Re: [HACKERS] Open 6.5 items
Дата
Msg-id m10lxwe-0000bIC@druid.net
обсуждение исходный текст
Ответ на Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Open 6.5 items  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: [HACKERS] Updated 6.5 HISTORY
Следующее
От: "D'Arcy" "J.M." Cain
Дата:
Сообщение: Re: [HACKERS] Updated 6.5 HISTORY