Re: mac.c - Mailing list pgsql-hackers

From Larry Rosenman
Subject Re: mac.c
Date
Msg-id 200007270231.e6R2V8607968@lerami.lerctr.org
Whole thread Raw
In response to Re: mac.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: mac.c  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
All I want to do now (given the size stuff), is to have a function and
possibly a type to compare the 24-bit OUI's, and give the tools
in /contrib to load a table using these from the IEEE's list.

No more hardcoded stuff in the db. 

Does this make more sense?

It's definately extensible, and frees code space.

Larry
> > > Anyway, tables are good, and we can make a function/operator pair which
> > > compares mac addresses on manufacturer only. Should be pretty easy.
> > > Shall we get started?
> >
> > OK, but what do we put into the table as the key?  just a 
> > 3 octet version of the OUI, or a full 6 octet, and use the function?
> > 
> > Thanks for the help.  
> 
> I hate to pour cold water on this, but it seems the whole idea of
> having a database function to find the manufacturer from an ethernet
> address is of questionable value.
> 
> Not that it can't be done in /contrib, but it is really important enough
> to do?   I recommend just removing the function.  I doubt anyone would
> miss it.
> 
> I have added a TODO item:
> 
> * Update macaddr manufacturer numbers, or remove the function macaddr_manuf()
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026


-- 
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: TOAST & vacuum
Next
From: Bruce Momjian
Date:
Subject: Re: Warnings triggered by recent includefile cleanups