unused_oids
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- #!/bin/sh
- # unused_oids
- #
- # $Header: /usr/local/cvsroot/pgsql/src/include/catalog/unused_oids,v 1.2 1998/12/31 20:09:49 momjian Exp $
- #
- # 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, "-", 2^14-1; /* current BootstrapObjectIdData value */
- }'