Thread: Re: FW: New function - hostmask
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
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
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