oidjoins.out

PostgreSQL 8.1.4的源码 适用于Linux下的开源数据库系统

--
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
--
SELECT	ctid, aggfnoid 
FROM	pg_catalog.pg_aggregate fk 
WHERE	aggfnoid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfnoid);
 ctid | aggfnoid 
------+----------
(0 rows)

SELECT	ctid, aggtransfn 
FROM	pg_catalog.pg_aggregate fk 
WHERE	aggtransfn != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggtransfn);
 ctid | aggtransfn 
------+------------
(0 rows)

SELECT	ctid, aggfinalfn 
FROM	pg_catalog.pg_aggregate fk 
WHERE	aggfinalfn != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfinalfn);
 ctid | aggfinalfn 
------+------------
(0 rows)

SELECT	ctid, aggsortop 
FROM	pg_catalog.pg_aggregate fk 
WHERE	aggsortop != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.aggsortop);
 ctid | aggsortop 
------+-----------
(0 rows)

SELECT	ctid, aggtranstype 
FROM	pg_catalog.pg_aggregate fk 
WHERE	aggtranstype != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
 ctid | aggtranstype 
------+--------------
(0 rows)

SELECT	ctid, aminsert 
FROM	pg_catalog.pg_am fk 
WHERE	aminsert != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aminsert);
 ctid | aminsert 
------+----------
(0 rows)

SELECT	ctid, ambeginscan 
FROM	pg_catalog.pg_am fk 
WHERE	ambeginscan != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambeginscan);
 ctid | ambeginscan 
------+-------------
(0 rows)

SELECT	ctid, amgettuple 
FROM	pg_catalog.pg_am fk 
WHERE	amgettuple != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgettuple);
 ctid | amgettuple 
------+------------
(0 rows)

SELECT	ctid, amgetmulti 
FROM	pg_catalog.pg_am fk 
WHERE	amgetmulti != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgetmulti);
 ctid | amgetmulti 
------+------------
(0 rows)

SELECT	ctid, amrescan 
FROM	pg_catalog.pg_am fk 
WHERE	amrescan != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrescan);
 ctid | amrescan 
------+----------
(0 rows)

SELECT	ctid, amendscan 
FROM	pg_catalog.pg_am fk 
WHERE	amendscan != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amendscan);
 ctid | amendscan 
------+-----------
(0 rows)

SELECT	ctid, ammarkpos 
FROM	pg_catalog.pg_am fk 
WHERE	ammarkpos != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ammarkpos);
 ctid | ammarkpos 
------+-----------
(0 rows)

SELECT	ctid, amrestrpos 
FROM	pg_catalog.pg_am fk 
WHERE	amrestrpos != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrestrpos);
 ctid | amrestrpos 
------+------------
(0 rows)

SELECT	ctid, ambuild 
FROM	pg_catalog.pg_am fk 
WHERE	ambuild != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambuild);
 ctid | ambuild 
------+---------
(0 rows)

SELECT	ctid, ambulkdelete 
FROM	pg_catalog.pg_am fk 
WHERE	ambulkdelete != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambulkdelete);
 ctid | ambulkdelete 
------+--------------
(0 rows)

SELECT	ctid, amvacuumcleanup 
FROM	pg_catalog.pg_am fk 
WHERE	amvacuumcleanup != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amvacuumcleanup);
 ctid | amvacuumcleanup 
------+-----------------
(0 rows)

SELECT	ctid, amcostestimate 
FROM	pg_catalog.pg_am fk 
WHERE	amcostestimate != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amcostestimate);
 ctid | amcostestimate 
------+----------------
(0 rows)

SELECT	ctid, amopclaid 
FROM	pg_catalog.pg_amop fk 
WHERE	amopclaid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid);
 ctid | amopclaid 
------+-----------
(0 rows)

SELECT	ctid, amopsubtype 
FROM	pg_catalog.pg_amop fk 
WHERE	amopsubtype != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amopsubtype);
 ctid | amopsubtype 
------+-------------
(0 rows)

SELECT	ctid, amopopr 
FROM	pg_catalog.pg_amop fk 
WHERE	amopopr != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.amopopr);
 ctid | amopopr 
------+---------
(0 rows)

SELECT	ctid, amopclaid 
FROM	pg_catalog.pg_amproc fk 
WHERE	amopclaid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid);
 ctid | amopclaid 
------+-----------
(0 rows)

SELECT	ctid, amprocsubtype 
FROM	pg_catalog.pg_amproc fk 
WHERE	amprocsubtype != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocsubtype);
 ctid | amprocsubtype 
------+---------------
(0 rows)

SELECT	ctid, amproc 
FROM	pg_catalog.pg_amproc fk 
WHERE	amproc != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
 ctid | amproc 
------+--------
(0 rows)

SELECT	ctid, attrelid 
FROM	pg_catalog.pg_attribute fk 
WHERE	attrelid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.attrelid);
 ctid | attrelid 
------+----------
(0 rows)

SELECT	ctid, atttypid 
FROM	pg_catalog.pg_attribute fk 
WHERE	atttypid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.atttypid);
 ctid | atttypid 
------+----------
(0 rows)

SELECT	ctid, castsource 
FROM	pg_catalog.pg_cast fk 
WHERE	castsource != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.castsource);
 ctid | castsource 
------+------------
(0 rows)

SELECT	ctid, casttarget 
FROM	pg_catalog.pg_cast fk 
WHERE	casttarget != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.casttarget);
 ctid | casttarget 
------+------------
(0 rows)

SELECT	ctid, castfunc 
FROM	pg_catalog.pg_cast fk 
WHERE	castfunc != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.castfunc);
 ctid | castfunc 
------+----------
(0 rows)

SELECT	ctid, relnamespace 
FROM	pg_catalog.pg_class fk 
WHERE	relnamespace != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.relnamespace);
 ctid | relnamespace 
------+--------------
(0 rows)

SELECT	ctid, reltype 
FROM	pg_catalog.pg_class fk 
WHERE	reltype != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reltype);
 ctid | reltype 
------+---------
(0 rows)

SELECT	ctid, relam 
FROM	pg_catalog.pg_class fk 
WHERE	relam != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam);
 ctid | relam 
------+-------
(0 rows)

SELECT	ctid, reltablespace 
FROM	pg_catalog.pg_class fk 
WHERE	reltablespace != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace);
 ctid | reltablespace 
------+---------------
(0 rows)

SELECT	ctid, reltoastrelid 
FROM	pg_catalog.pg_class fk 
WHERE	reltoastrelid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
 ctid | reltoastrelid 
------+---------------
(0 rows)

SELECT	ctid, reltoastidxid 
FROM	pg_catalog.pg_class fk 
WHERE	reltoastidxid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastidxid);
 ctid | reltoastidxid 
------+---------------
(0 rows)

SELECT	ctid, connamespace 
FROM	pg_catalog.pg_constraint fk 
WHERE	connamespace != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
 ctid | connamespace 
------+--------------
(0 rows)

SELECT	ctid, contypid 
FROM	pg_catalog.pg_constraint fk 
WHERE	contypid != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
 ctid | contypid 
------+----------
(0 rows)

SELECT	ctid, connamespace 
FROM	pg_catalog.pg_conversion fk 
WHERE	connamespace != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
 ctid | connamespace 
------+--------------
(0 rows)

SELECT	ctid, conproc 
FROM	pg_catalog.pg_conversion fk 
WHERE	conproc != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
 ctid | conproc 
------+---------
(0 rows)

SELECT	ctid, dattablespace 
FROM	pg_catalog.pg_database fk 
WHERE	dattablespace != 0 AND 
	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace);
 ctid | dattablespace 
------+---------------
(0 rows)

SELECT	ctid, classid 
FROM	pg_catalog.pg_depend fk 
WHERE	classid != 0 AND