Thread: New MAC OUI capabilities

I've committed changes to the main tree which update the pg_proc system
catalog, so initdb is required.

As discussed recently, I've added some contrib/mac/ routines to support
generating a table, macoui, which contains current manufacturers'
identification fields for hardware MAC addresses. I've made a few other
changes, including dropping the macaddr_manuf() built-in function.

Note that I did *not* add a current copy of the oui.txt file from IEEE,
since it is over half a meg uncompressed. But we could add it to cvs if
it is advisable.

The contrib/mac directory does not yet have a README, but should.

More details below...
                    - Thomas

The CVS log:

Add functions to convert to and from text, and to truncate to MAC OUI.
Remove hardcoded macaddr_manuf(), which had really old, obsolete info.Replace this with some contrib/mac/ code to
maniagOUI info from IEEE.
 

Thomas Lockhart <lockhart@alumni.caltech.edu> writes:
> Note that I did *not* add a current copy of the oui.txt file from IEEE,
> since it is over half a meg uncompressed. But we could add it to cvs if
> it is advisable.

Then we'd have to worry about keeping it up to date.  That's also
more distribution-bloat than I think is advisable for a relatively
little-used feature.  I vote for just providing a README that tells
where to get the current oui.txt file.
        regards, tom lane

> Then we'd have to worry about keeping it up to date.  That's also
> more distribution-bloat than I think is advisable for a relatively
> little-used feature.  I vote for just providing a README that tells
> where to get the current oui.txt file.

We do even better than that: there is an "updateoui" routine which uses
wget to go out and fetch the file for you.
                  - Thomas