--
-- OIDJOIN
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_check
--
SELECT oid, pg_aggregate.aggtransfn1 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggtransfn1 != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_aggregate.aggtransfn1);
 oid | aggtransfn1 
-----+-------------
(0 rows)

SELECT oid, pg_aggregate.aggtransfn2 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggtransfn2 != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_aggregate.aggtransfn2);
 oid | aggtransfn2 
-----+-------------
(0 rows)

SELECT oid, pg_aggregate.aggfinalfn 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggfinalfn != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_aggregate.aggfinalfn);
 oid | aggfinalfn 
-----+------------
(0 rows)

SELECT oid, pg_aggregate.aggbasetype 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggbasetype != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_aggregate.aggbasetype);
 oid | aggbasetype 
-----+-------------
(0 rows)

SELECT oid, pg_aggregate.aggtranstype1 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggtranstype1 != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_aggregate.aggtranstype1);
 oid | aggtranstype1 
-----+---------------
(0 rows)

SELECT oid, pg_aggregate.aggtranstype2 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggtranstype2 != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_aggregate.aggtranstype2);
 oid | aggtranstype2 
-----+---------------
(0 rows)

SELECT oid, pg_aggregate.aggfinaltype 
  FROM pg_aggregate 
  WHERE pg_aggregate.aggfinaltype != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_aggregate.aggfinaltype);
 oid | aggfinaltype 
-----+--------------
(0 rows)

SELECT oid, pg_am.amgettuple 
  FROM pg_am 
  WHERE pg_am.amgettuple != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amgettuple);
 oid | amgettuple 
-----+------------
(0 rows)

SELECT oid, pg_am.aminsert 
  FROM pg_am 
  WHERE pg_am.aminsert != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.aminsert);
 oid | aminsert 
-----+----------
(0 rows)

SELECT oid, pg_am.amdelete 
  FROM pg_am 
  WHERE pg_am.amdelete != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amdelete);
 oid | amdelete 
-----+----------
(0 rows)

SELECT oid, pg_am.ambeginscan 
  FROM pg_am 
  WHERE pg_am.ambeginscan != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ambeginscan);
 oid | ambeginscan 
-----+-------------
(0 rows)

SELECT oid, pg_am.amrescan 
  FROM pg_am 
  WHERE pg_am.amrescan != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amrescan);
 oid | amrescan 
-----+----------
(0 rows)

SELECT oid, pg_am.amendscan 
  FROM pg_am 
  WHERE pg_am.amendscan != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amendscan);
 oid | amendscan 
-----+-----------
(0 rows)

SELECT oid, pg_am.ammarkpos 
  FROM pg_am 
  WHERE pg_am.ammarkpos != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ammarkpos);
 oid | ammarkpos 
-----+-----------
(0 rows)

SELECT oid, pg_am.amrestrpos 
  FROM pg_am 
  WHERE pg_am.amrestrpos != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.amrestrpos);
 oid | amrestrpos 
-----+------------
(0 rows)

SELECT oid, pg_am.ambuild 
  FROM pg_am 
  WHERE pg_am.ambuild != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_am.ambuild);
 oid | ambuild 
-----+---------
(0 rows)

SELECT oid, pg_amop.amopid 
  FROM pg_amop 
  WHERE pg_amop.amopid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_am AS t1 WHERE t1.oid = pg_amop.amopid);
 oid | amopid 
-----+--------
(0 rows)

SELECT oid, pg_amop.amopclaid 
  FROM pg_amop 
  WHERE pg_amop.amopclaid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_opclass AS t1 WHERE t1.oid = pg_amop.amopclaid);
 oid | amopclaid 
-----+-----------
(0 rows)

SELECT oid, pg_amop.amopopr 
  FROM pg_amop 
  WHERE pg_amop.amopopr != 0 AND 
    NOT EXISTS(SELECT * FROM pg_operator AS t1 WHERE t1.oid = pg_amop.amopopr);
 oid | amopopr 
-----+---------
(0 rows)

SELECT oid, pg_amop.amopselect 
  FROM pg_amop 
  WHERE pg_amop.amopselect != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_amop.amopselect);
 oid | amopselect 
-----+------------
(0 rows)

SELECT oid, pg_amop.amopnpages 
  FROM pg_amop 
  WHERE pg_amop.amopnpages != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_amop.amopnpages);
 oid | amopnpages 
-----+------------
(0 rows)

SELECT oid, pg_amproc.amid 
  FROM pg_amproc 
  WHERE pg_amproc.amid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_am AS t1 WHERE t1.oid = pg_amproc.amid);
 oid | amid 
-----+------
(0 rows)

SELECT oid, pg_amproc.amopclaid 
  FROM pg_amproc 
  WHERE pg_amproc.amopclaid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_opclass AS t1 WHERE t1.oid = pg_amproc.amopclaid);
 oid | amopclaid 
-----+-----------
(0 rows)

SELECT oid, pg_amproc.amproc 
  FROM pg_amproc 
  WHERE pg_amproc.amproc != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_amproc.amproc);
 oid | amproc 
-----+--------
(0 rows)

SELECT oid, pg_attribute.attrelid 
  FROM pg_attribute 
  WHERE pg_attribute.attrelid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_class AS t1 WHERE t1.oid = pg_attribute.attrelid);
 oid | attrelid 
-----+----------
(0 rows)

SELECT oid, pg_attribute.atttypid 
  FROM pg_attribute 
  WHERE pg_attribute.atttypid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_attribute.atttypid);
 oid | atttypid 
-----+----------
(0 rows)

SELECT oid, pg_class.reltype 
  FROM pg_class 
  WHERE pg_class.reltype != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_class.reltype);
 oid | reltype 
-----+---------
(0 rows)

SELECT oid, pg_class.relam 
  FROM pg_class 
  WHERE pg_class.relam != 0 AND 
    NOT EXISTS(SELECT * FROM pg_am AS t1 WHERE t1.oid = pg_class.relam);
 oid | relam 
-----+-------
(0 rows)

SELECT oid, pg_index.indexrelid 
  FROM pg_index 
  WHERE pg_index.indexrelid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_class AS t1 WHERE t1.oid = pg_index.indexrelid);
 oid | indexrelid 
-----+------------
(0 rows)

SELECT oid, pg_index.indrelid 
  FROM pg_index 
  WHERE pg_index.indrelid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_class AS t1 WHERE t1.oid = pg_index.indrelid);
 oid | indrelid 
-----+----------
(0 rows)

SELECT oid, pg_opclass.opcdeftype 
  FROM pg_opclass 
  WHERE pg_opclass.opcdeftype != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_opclass.opcdeftype);
 oid | opcdeftype 
-----+------------
(0 rows)

SELECT oid, pg_operator.oprleft 
  FROM pg_operator 
  WHERE pg_operator.oprleft != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_operator.oprleft);
 oid | oprleft 
-----+---------
(0 rows)

SELECT oid, pg_operator.oprright 
  FROM pg_operator 
  WHERE pg_operator.oprright != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_operator.oprright);
 oid | oprright 
-----+----------
(0 rows)

SELECT oid, pg_operator.oprresult 
  FROM pg_operator 
  WHERE pg_operator.oprresult != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_operator.oprresult);
 oid | oprresult 
-----+-----------
(0 rows)

SELECT oid, pg_operator.oprcom 
  FROM pg_operator 
  WHERE pg_operator.oprcom != 0 AND 
    NOT EXISTS(SELECT * FROM pg_operator AS t1 WHERE t1.oid = pg_operator.oprcom);
 oid | oprcom 
-----+--------
(0 rows)

SELECT oid, pg_operator.oprnegate 
  FROM pg_operator 
  WHERE pg_operator.oprnegate != 0 AND 
    NOT EXISTS(SELECT * FROM pg_operator AS t1 WHERE t1.oid = pg_operator.oprnegate);
 oid | oprnegate 
-----+-----------
(0 rows)

SELECT oid, pg_operator.oprlsortop 
  FROM pg_operator 
  WHERE pg_operator.oprlsortop != 0 AND 
    NOT EXISTS(SELECT * FROM pg_operator AS t1 WHERE t1.oid = pg_operator.oprlsortop);
 oid | oprlsortop 
-----+------------
(0 rows)

SELECT oid, pg_operator.oprrsortop 
  FROM pg_operator 
  WHERE pg_operator.oprrsortop != 0 AND 
    NOT EXISTS(SELECT * FROM pg_operator AS t1 WHERE t1.oid = pg_operator.oprrsortop);
 oid | oprrsortop 
-----+------------
(0 rows)

SELECT oid, pg_operator.oprcode 
  FROM pg_operator 
  WHERE pg_operator.oprcode != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_operator.oprcode);
 oid | oprcode 
-----+---------
(0 rows)

SELECT oid, pg_operator.oprrest 
  FROM pg_operator 
  WHERE pg_operator.oprrest != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_operator.oprrest);
 oid | oprrest 
-----+---------
(0 rows)

SELECT oid, pg_operator.oprjoin 
  FROM pg_operator 
  WHERE pg_operator.oprjoin != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_operator.oprjoin);
 oid | oprjoin 
-----+---------
(0 rows)

SELECT oid, pg_proc.prolang 
  FROM pg_proc 
  WHERE pg_proc.prolang != 0 AND 
    NOT EXISTS(SELECT * FROM pg_language AS t1 WHERE t1.oid = pg_proc.prolang);
 oid | prolang 
-----+---------
(0 rows)

SELECT oid, pg_proc.prorettype 
  FROM pg_proc 
  WHERE pg_proc.prorettype != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_proc.prorettype);
 oid | prorettype 
-----+------------
(0 rows)

SELECT oid, pg_rewrite.ev_class 
  FROM pg_rewrite 
  WHERE pg_rewrite.ev_class != 0 AND 
    NOT EXISTS(SELECT * FROM pg_class AS t1 WHERE t1.oid = pg_rewrite.ev_class);
 oid | ev_class 
-----+----------
(0 rows)

SELECT oid, pg_type.typrelid 
  FROM pg_type 
  WHERE pg_type.typrelid != 0 AND 
    NOT EXISTS(SELECT * FROM pg_class AS t1 WHERE t1.oid = pg_type.typrelid);
 oid | typrelid 
-----+----------
(0 rows)

SELECT oid, pg_type.typelem 
  FROM pg_type 
  WHERE pg_type.typelem != 0 AND 
    NOT EXISTS(SELECT * FROM pg_type AS t1 WHERE t1.oid = pg_type.typelem);
 oid | typelem 
-----+---------
(0 rows)

SELECT oid, pg_type.typinput 
  FROM pg_type 
  WHERE pg_type.typinput != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_type.typinput);
 oid | typinput 
-----+----------
(0 rows)

SELECT oid, pg_type.typoutput 
  FROM pg_type 
  WHERE pg_type.typoutput != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_type.typoutput);
 oid | typoutput 
-----+-----------
(0 rows)

SELECT oid, pg_type.typreceive 
  FROM pg_type 
  WHERE pg_type.typreceive != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_type.typreceive);
 oid | typreceive 
-----+------------
(0 rows)

SELECT oid, pg_type.typsend 
  FROM pg_type 
  WHERE pg_type.typsend != 0 AND 
    NOT EXISTS(SELECT * FROM pg_proc AS t1 WHERE t1.oid = pg_type.typsend);
 oid | typsend 
-----+---------
(0 rows)

