Re: Update: mac.c update, patch now on ftp

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: Larry Rosenman <ler(at)lerctr(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Update: mac.c update, patch now on ftp
Date: 2000-07-18 11:50:25
Message-ID: 200007181150.e6IBoPa25951@lerami.lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I was thinking of making the following:

1) macaddr_manuf function that returns the first 3 octets of a macaddr
2) a macaddr_manuf TYPE that can be used for the table
3) supply the ouiparse.awk to generate a set of INSERT statements
to load a table
4) allow the above table to be indexed.

What does the group think of this?

Larry Rosenman
> > The code in mac.c does a LINEAR search, and the list is only going to
> > grow. It's at 4110+ OUI's that are PUBLIC.).
>
> Yuck. Let's put it into a (user loadable) table. And rather than having
> macaddr_manuf(), we should just have a "sametype()" (or whatever) which
> can compare an arbitrary mac address with another one. Then
>
> select brand from mactypes where '03:04:...' = macmask;
>
> or at least
>
> select brand from mactypes where sametype('03:04:...',macmask);
>
> would get you the right thing.
>
> I can help with these internals, if that is the right way to head.
>
> - Thomas

--
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Lamar Owen 2000-07-18 11:54:41 Re: Untrusted PL/Tcl?
Previous Message Jan Wieck 2000-07-18 11:36:22 Untrusted PL/Tcl?