diff options
| author | Tom Lane | 2006-09-05 17:20:29 +0000 |
|---|---|---|
| committer | Tom Lane | 2006-09-05 17:20:29 +0000 |
| commit | af7d257e21aae3d75c46977482309b658b3a29d7 (patch) | |
| tree | cf93e41a5d1c182cc80f5c9122bd34a3d52caf20 /contrib/mac/createoui | |
| parent | a3242fb42cc2b85581a195aa72cf72a1df94b78f (diff) | |
Remove contrib modules that have been migrated to pgfoundry: adddepend,
dbase, dbmirror, fulltextindex, mac, userlock; or abandoned: mSQL-interface,
tips.
Diffstat (limited to 'contrib/mac/createoui')
| -rwxr-xr-x | contrib/mac/createoui | 55 |
1 files changed, 0 insertions, 55 deletions
diff --git a/contrib/mac/createoui b/contrib/mac/createoui deleted file mode 100755 index eaf4dbfac0e..00000000000 --- a/contrib/mac/createoui +++ /dev/null @@ -1,55 +0,0 @@ -#! /bin/sh - -# $PostgreSQL: pgsql/contrib/mac/createoui,v 1.3 2006/03/11 04:38:30 momjian Exp $ - -# Utility to create manufacturer's oui table -# OUI is "Organizationally Unique Identifier" assigned by IEEE. -# There are currently three duplicate listings, so we can not enforce -# uniqueness in the OUI field. -# - thomas 2000-08-21 - -args= -update=0 - -while [ $# -gt 0 ] -do - case "$1" in - --update) - update=1 - ;; - --noupdate) - update=0 - ;; - --help) - echo "Usage: $0 --[no]update dbname" - exit - ;; - *) - args="$args $1" - ;; - esac - shift -done - -psql -e $args <<EOF --- Table containing OUI portions of MAC address and manufacturer's name -create table macoui ( - addr macaddr not null, - name text not null -); - --- Create an index to help lookups -create index macoui_idx on macoui (addr); - --- Function to return manufacturer's name given MAC address -create function manuf (macaddr) - returns text as ' - select name from macoui m where trunc(\$1) = m.addr; -' language SQL; -EOF - -if [ $update -gt 0 ]; then - updateoui $args -fi - -exit |
