Skip site navigation (1) Skip section navigation (2)

Re: mac.c

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Larry Rosenman <ler(at)lerctr(dot)org>, Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>, pgsql-hackers(at)hub(dot)org
Subject: Re: mac.c
Date: 2000-07-27 02:31:08
Message-ID: 200007270231.e6R2V8607968@lerami.lerctr.org (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

In response to

  • Re: mac.c at 2000-07-27 01:13:41 from Bruce Momjian

Responses

  • Re: mac.c at 2000-07-27 03:54:31 from Bruce Momjian

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2000-07-27 03:13:46
Subject: Re: Warnings triggered by recent includefile cleanups
Previous:From: Bruce MomjianDate: 2000-07-27 02:10:05
Subject: Re: TOAST & vacuum

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group