tenk2 | t

(53 rows)

--

-- another sanity check: every system catalog that has OIDs should have

-- a unique index on OID. This ensures that the OIDs will be unique,

-- even after the OID counter wraps around.

-- We exclude non-system tables from the check by looking at nspname.

--

SELECT relname, nspname

FROM pg_class c LEFT JOIN pg_namespace n ON n.oid = relnamespace

WHERE relhasoids

AND ((nspname ~ '^pg_') IS NOT FALSE)

AND NOT EXISTS (SELECT 1 FROM pg_index i WHERE indrelid = c.oid

AND indkey[0] = -2 AND indkey[1] = 0 AND indisunique);

relname | nspname

---------+---------

(0 rows)

VACUUM;

WHERE relhasindexAND relkind!='t'

ORDER BY relname;

SELECT relname, nspname

FROM pg_class cLEFT JOIN pg_namespace nONn.oid= relnamespace

WHERE relhasoids

AND ((nspname ~'^pg_') IS NOT FALSE)

AND NOT EXISTS (SELECT1FROM pg_index iWHERE indrelid=c.oid

AND indkey[0]=-2AND indkey[1]=0AND indisunique);