duplicate_oids

来自「关系型数据库 Postgresql 6.5.2」· 代码 · 共 24 行

#!/bin/sh
#
# duplicate_oids
#
# finds oids that are duplicated in the system tables.
#

# no multibytes files
FILES=`ls pg_*.h |grep -v '_mb.h'`

egrep '^DATA' $FILES | \
	sed -e 's/^.*OID[^=]*=[^0-9]*//' -e 's/[^0-9].*$//' | \
	sort -n >/tmp/alloids.$$
uniq /tmp/alloids.$$ >/tmp/uniqoids.$$
diff -u /tmp/alloids.$$ /tmp/uniqoids.$$ | \
	grep -v '/tmp/' | \
	grep '^-' | \
	sed -e 's/^-//' | \
	grep -v '^0$' | \
	uniq
rm /tmp/alloids.$$
rm /tmp/uniqoids.$$