Re: FW: New function - hostmask
От | Bruce Momjian |
---|---|
Тема | Re: FW: New function - hostmask |
Дата | |
Msg-id | 200303212116.h2LLGuY12861@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: FW: New function - hostmask (Larry Rosenman <ler@lerctr.org>) |
Список | pgsql-general |
OK, that's all I needed to know before adding it. Thanks. --------------------------------------------------------------------------- Larry Rosenman wrote: > Yes, I would. > > I use a PostgreSQL backed IP management database (home grown, written by > yours truly), and > with some of the enhancements we are looking at, this would be useful. > > LER > > > --On Friday, March 21, 2003 15:46:02 -0500 Bruce Momjian > <pgman@candle.pha.pa.us> wrote: > > > > > Does anyone see value in a hostmask function() --- description below? > > > > ------------------------------------------------------------------------- > > -- > > > > greg wrote: > >> ] -----Original Message----- > >> ] From: Bruce Momjian [mailto:pgman@candle.pha.pa.us] > >> ] Sent: Friday, March 07, 2003 12:25 PM > >> ] To: greg > >> ] Subject: Re: FW: New function - hostmask > >> ] > >> ] > >> ] > >> ] Oh, OK. We usually need a larger value to add a function to > >> ] the main distribution. Would you see if you can find another > >> ] user who thinks this is valuable? > >> ] > >> ] -------------------------------------------------------------- > >> ] ------------- > >> ] > >> ] greg wrote: > >> ] > Hi Bruce, > >> ] > > >> ] > I don't think I got your email in response. > >> ] > > >> ] > Yes. I think it has good value. I'm generating cisco network > >> ] > configurations out of a database and in the OSPF > >> ] configuration area a > >> ] > hostmask is used (rather than a netmask) to define a subnet. Ie: > >> ] > > >> ] > router ospf 18062 > >> ] > network 202.0.98.51 0.0.0.0 area 0 > >> ] > network 202.0.98.52 0.0.0.3 area 0 > >> ] > > >> ] > Where as the netmask is used for similar functionality in bgp (and > >> ] > interface configurations): > >> ] > > >> ] > router bgp 18062 > >> ] > network 202.0.98.51 mask 255.255.255.255 route-map > >> ] > AS18062-INFRASTRUCTURE-ROUTE > >> ] > network 202.0.98.52 mask 255.255.255.252 route-map > >> ] > AS18062-INFRASTRUCTURE-ROUTE > >> ] > > >> ] > interface Loopback0 > >> ] > ip address 202.0.98.49 255.255.255.255 > >> ] > > >> ] > It's an annoying cisco'ism. There are ways to work around the > >> ] > deficiency. However having a native function to generate a hostmask > >> ] > from a CIDR value is a natural extension to the existing inet > >> ] > functions already in PostgreSQL. > >> ] > > > > > -- > > Bruce Momjian | http://candle.pha.pa.us > > pgman@candle.pha.pa.us | (610) 359-1001 > > + If your life is a hard drive, | 13 Roberts Road > > + Christ can be your backup. | Newtown Square, Pennsylvania > > 19073 > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > > > > > > -- > Larry Rosenman http://www.lerctr.org/~ler > Phone: +1 972-414-9812 E-Mail: ler@lerctr.org > US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749 > > > > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: