head	1.1;
access;
symbols
	release_4_2:1.1
	aix_ok:1.1;
locks; strict;
comment	@# @;


1.1
date	93.07.01.08.49.53;	author aoki;	state Exp;
branches;
next	;


desc
@cheapo script to find unused blocks of oids in the catalogs
@


1.1
log
@Initial revision
@
text
@#!/bin/sh
# unused_oids
#
# $Header$
#
#	finds blocks of oids that have not already been claimed by 
#	post_hackers for internal purposes.  primarily useful for
#	finding valid oids for new internal function oids.  the numbers
#	printed are inclusive ranges of valid (unused) oids.
#
#	before using a large empty block, make sure you aren't about
#	to take over what was intended as expansion space for something
#	else.  also, before using a number, do a "grepsrc" to make sure 
#	that someone isn't using a literal numeric constant somewhere..
#
#	non-berkeley post_hackers should probably not try to use oids 
#	less than the highest one that comes with the distributed source.
#
#	run this script in src/backend/catalog.
#
egrep '^DATA' pg_*.h | \
	sed -e 's/^.*OID[^=]*=[^0-9]*//' -e 's/[^0-9].*$//' | \
	sort -n | \
	uniq | \
	awk '
BEGIN {
	last = 0;
}
/^[0-9]/ {
	if ($1 > last + 1) {
		if ($1 > last + 2) {
			print last + 1, "-", $1 - 1;
		} else {
			print last + 1;
		}
	}
	last = $1;
}
END {
	print last + 1, "-";
}'
@
