2 -- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
5 FROM pg_catalog.pg_aggregate fk
6 WHERE aggfnoid != 0 AND
7 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfnoid);
12 SELECT ctid, aggtransfn
13 FROM pg_catalog.pg_aggregate fk
14 WHERE aggtransfn != 0 AND
15 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggtransfn);
20 SELECT ctid, aggfinalfn
21 FROM pg_catalog.pg_aggregate fk
22 WHERE aggfinalfn != 0 AND
23 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfinalfn);
28 SELECT ctid, aggsortop
29 FROM pg_catalog.pg_aggregate fk
30 WHERE aggsortop != 0 AND
31 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.aggsortop);
36 SELECT ctid, aggtranstype
37 FROM pg_catalog.pg_aggregate fk
38 WHERE aggtranstype != 0 AND
39 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
44 SELECT ctid, amkeytype
45 FROM pg_catalog.pg_am fk
46 WHERE amkeytype != 0 AND
47 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
53 FROM pg_catalog.pg_am fk
54 WHERE aminsert != 0 AND
55 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aminsert);
60 SELECT ctid, ambeginscan
61 FROM pg_catalog.pg_am fk
62 WHERE ambeginscan != 0 AND
63 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambeginscan);
68 SELECT ctid, amgettuple
69 FROM pg_catalog.pg_am fk
70 WHERE amgettuple != 0 AND
71 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgettuple);
76 SELECT ctid, amgetbitmap
77 FROM pg_catalog.pg_am fk
78 WHERE amgetbitmap != 0 AND
79 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgetbitmap);
85 FROM pg_catalog.pg_am fk
86 WHERE amrescan != 0 AND
87 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrescan);
92 SELECT ctid, amendscan
93 FROM pg_catalog.pg_am fk
94 WHERE amendscan != 0 AND
95 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amendscan);
100 SELECT ctid, ammarkpos
101 FROM pg_catalog.pg_am fk
102 WHERE ammarkpos != 0 AND
103 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ammarkpos);
108 SELECT ctid, amrestrpos
109 FROM pg_catalog.pg_am fk
110 WHERE amrestrpos != 0 AND
111 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrestrpos);
117 FROM pg_catalog.pg_am fk
118 WHERE ambuild != 0 AND
119 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambuild);
124 SELECT ctid, ambulkdelete
125 FROM pg_catalog.pg_am fk
126 WHERE ambulkdelete != 0 AND
127 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambulkdelete);
129 ------+--------------
132 SELECT ctid, amvacuumcleanup
133 FROM pg_catalog.pg_am fk
134 WHERE amvacuumcleanup != 0 AND
135 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amvacuumcleanup);
136 ctid | amvacuumcleanup
137 ------+-----------------
140 SELECT ctid, amcostestimate
141 FROM pg_catalog.pg_am fk
142 WHERE amcostestimate != 0 AND
143 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amcostestimate);
144 ctid | amcostestimate
145 ------+----------------
148 SELECT ctid, amoptions
149 FROM pg_catalog.pg_am fk
150 WHERE amoptions != 0 AND
151 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amoptions);
156 SELECT ctid, amopfamily
157 FROM pg_catalog.pg_amop fk
158 WHERE amopfamily != 0 AND
159 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amopfamily);
164 SELECT ctid, amoplefttype
165 FROM pg_catalog.pg_amop fk
166 WHERE amoplefttype != 0 AND
167 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoplefttype);
169 ------+--------------
172 SELECT ctid, amoprighttype
173 FROM pg_catalog.pg_amop fk
174 WHERE amoprighttype != 0 AND
175 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoprighttype);
177 ------+---------------
181 FROM pg_catalog.pg_amop fk
182 WHERE amopopr != 0 AND
183 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.amopopr);
188 SELECT ctid, amopmethod
189 FROM pg_catalog.pg_amop fk
190 WHERE amopmethod != 0 AND
191 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.amopmethod);
196 SELECT ctid, amprocfamily
197 FROM pg_catalog.pg_amproc fk
198 WHERE amprocfamily != 0 AND
199 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amprocfamily);
201 ------+--------------
204 SELECT ctid, amproclefttype
205 FROM pg_catalog.pg_amproc fk
206 WHERE amproclefttype != 0 AND
207 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amproclefttype);
208 ctid | amproclefttype
209 ------+----------------
212 SELECT ctid, amprocrighttype
213 FROM pg_catalog.pg_amproc fk
214 WHERE amprocrighttype != 0 AND
215 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocrighttype);
216 ctid | amprocrighttype
217 ------+-----------------
221 FROM pg_catalog.pg_amproc fk
222 WHERE amproc != 0 AND
223 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
228 SELECT ctid, attrelid
229 FROM pg_catalog.pg_attribute fk
230 WHERE attrelid != 0 AND
231 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.attrelid);
236 SELECT ctid, atttypid
237 FROM pg_catalog.pg_attribute fk
238 WHERE atttypid != 0 AND
239 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.atttypid);
244 SELECT ctid, castsource
245 FROM pg_catalog.pg_cast fk
246 WHERE castsource != 0 AND
247 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.castsource);
252 SELECT ctid, casttarget
253 FROM pg_catalog.pg_cast fk
254 WHERE casttarget != 0 AND
255 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.casttarget);
260 SELECT ctid, castfunc
261 FROM pg_catalog.pg_cast fk
262 WHERE castfunc != 0 AND
263 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.castfunc);
268 SELECT ctid, relnamespace
269 FROM pg_catalog.pg_class fk
270 WHERE relnamespace != 0 AND
271 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.relnamespace);
273 ------+--------------
277 FROM pg_catalog.pg_class fk
278 WHERE reltype != 0 AND
279 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reltype);
284 SELECT ctid, relowner
285 FROM pg_catalog.pg_class fk
286 WHERE relowner != 0 AND
287 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.relowner);
293 FROM pg_catalog.pg_class fk
295 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam);
300 SELECT ctid, reltablespace
301 FROM pg_catalog.pg_class fk
302 WHERE reltablespace != 0 AND
303 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace);
305 ------+---------------
308 SELECT ctid, reltoastrelid
309 FROM pg_catalog.pg_class fk
310 WHERE reltoastrelid != 0 AND
311 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
313 ------+---------------
316 SELECT ctid, reltoastidxid
317 FROM pg_catalog.pg_class fk
318 WHERE reltoastidxid != 0 AND
319 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastidxid);
321 ------+---------------
324 SELECT ctid, connamespace
325 FROM pg_catalog.pg_constraint fk
326 WHERE connamespace != 0 AND
327 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
329 ------+--------------
332 SELECT ctid, contypid
333 FROM pg_catalog.pg_constraint fk
334 WHERE contypid != 0 AND
335 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
340 SELECT ctid, connamespace
341 FROM pg_catalog.pg_conversion fk
342 WHERE connamespace != 0 AND
343 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
345 ------+--------------
348 SELECT ctid, conowner
349 FROM pg_catalog.pg_conversion fk
350 WHERE conowner != 0 AND
351 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.conowner);
357 FROM pg_catalog.pg_conversion fk
358 WHERE conproc != 0 AND
359 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
365 FROM pg_catalog.pg_database fk
366 WHERE datdba != 0 AND
367 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.datdba);
372 SELECT ctid, dattablespace
373 FROM pg_catalog.pg_database fk
374 WHERE dattablespace != 0 AND
375 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace);
377 ------+---------------
380 SELECT ctid, setdatabase
381 FROM pg_catalog.pg_db_role_setting fk
382 WHERE setdatabase != 0 AND
383 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_database pk WHERE pk.oid = fk.setdatabase);
389 FROM pg_catalog.pg_depend fk
390 WHERE classid != 0 AND
391 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
396 SELECT ctid, refclassid
397 FROM pg_catalog.pg_depend fk
398 WHERE refclassid != 0 AND
399 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
404 SELECT ctid, classoid
405 FROM pg_catalog.pg_description fk
406 WHERE classoid != 0 AND
407 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
412 SELECT ctid, indexrelid
413 FROM pg_catalog.pg_index fk
414 WHERE indexrelid != 0 AND
415 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
420 SELECT ctid, indrelid
421 FROM pg_catalog.pg_index fk
422 WHERE indrelid != 0 AND
423 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
428 SELECT ctid, lanowner
429 FROM pg_catalog.pg_language fk
430 WHERE lanowner != 0 AND
431 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lanowner);
436 SELECT ctid, lanplcallfoid
437 FROM pg_catalog.pg_language fk
438 WHERE lanplcallfoid != 0 AND
439 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanplcallfoid);
441 ------+---------------
444 SELECT ctid, laninline
445 FROM pg_catalog.pg_language fk
446 WHERE laninline != 0 AND
447 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.laninline);
452 SELECT ctid, lanvalidator
453 FROM pg_catalog.pg_language fk
454 WHERE lanvalidator != 0 AND
455 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
457 ------+--------------
460 SELECT ctid, nspowner
461 FROM pg_catalog.pg_namespace fk
462 WHERE nspowner != 0 AND
463 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.nspowner);
468 SELECT ctid, opcmethod
469 FROM pg_catalog.pg_opclass fk
470 WHERE opcmethod != 0 AND
471 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcmethod);
476 SELECT ctid, opcnamespace
477 FROM pg_catalog.pg_opclass fk
478 WHERE opcnamespace != 0 AND
479 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
481 ------+--------------
484 SELECT ctid, opcowner
485 FROM pg_catalog.pg_opclass fk
486 WHERE opcowner != 0 AND
487 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opcowner);
492 SELECT ctid, opcfamily
493 FROM pg_catalog.pg_opclass fk
494 WHERE opcfamily != 0 AND
495 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
500 SELECT ctid, opcintype
501 FROM pg_catalog.pg_opclass fk
502 WHERE opcintype != 0 AND
503 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
508 SELECT ctid, opckeytype
509 FROM pg_catalog.pg_opclass fk
510 WHERE opckeytype != 0 AND
511 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opckeytype);
516 SELECT ctid, oprnamespace
517 FROM pg_catalog.pg_operator fk
518 WHERE oprnamespace != 0 AND
519 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
521 ------+--------------
524 SELECT ctid, oprowner
525 FROM pg_catalog.pg_operator fk
526 WHERE oprowner != 0 AND
527 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.oprowner);
533 FROM pg_catalog.pg_operator fk
534 WHERE oprleft != 0 AND
535 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
540 SELECT ctid, oprright
541 FROM pg_catalog.pg_operator fk
542 WHERE oprright != 0 AND
543 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
548 SELECT ctid, oprresult
549 FROM pg_catalog.pg_operator fk
550 WHERE oprresult != 0 AND
551 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
557 FROM pg_catalog.pg_operator fk
558 WHERE oprcom != 0 AND
559 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
564 SELECT ctid, oprnegate
565 FROM pg_catalog.pg_operator fk
566 WHERE oprnegate != 0 AND
567 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
573 FROM pg_catalog.pg_operator fk
574 WHERE oprcode != 0 AND
575 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
581 FROM pg_catalog.pg_operator fk
582 WHERE oprrest != 0 AND
583 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
589 FROM pg_catalog.pg_operator fk
590 WHERE oprjoin != 0 AND
591 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
596 SELECT ctid, opfmethod
597 FROM pg_catalog.pg_opfamily fk
598 WHERE opfmethod != 0 AND
599 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opfmethod);
604 SELECT ctid, opfnamespace
605 FROM pg_catalog.pg_opfamily fk
606 WHERE opfnamespace != 0 AND
607 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opfnamespace);
609 ------+--------------
612 SELECT ctid, opfowner
613 FROM pg_catalog.pg_opfamily fk
614 WHERE opfowner != 0 AND
615 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opfowner);
620 SELECT ctid, pronamespace
621 FROM pg_catalog.pg_proc fk
622 WHERE pronamespace != 0 AND
623 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
625 ------+--------------
628 SELECT ctid, proowner
629 FROM pg_catalog.pg_proc fk
630 WHERE proowner != 0 AND
631 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.proowner);
637 FROM pg_catalog.pg_proc fk
638 WHERE prolang != 0 AND
639 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
644 SELECT ctid, prorettype
645 FROM pg_catalog.pg_proc fk
646 WHERE prorettype != 0 AND
647 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
652 SELECT ctid, ev_class
653 FROM pg_catalog.pg_rewrite fk
654 WHERE ev_class != 0 AND
655 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
660 SELECT ctid, refclassid
661 FROM pg_catalog.pg_shdepend fk
662 WHERE refclassid != 0 AND
663 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
668 SELECT ctid, classoid
669 FROM pg_catalog.pg_shdescription fk
670 WHERE classoid != 0 AND
671 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
676 SELECT ctid, starelid
677 FROM pg_catalog.pg_statistic fk
678 WHERE starelid != 0 AND
679 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
685 FROM pg_catalog.pg_statistic fk
686 WHERE staop1 != 0 AND
687 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
693 FROM pg_catalog.pg_statistic fk
694 WHERE staop2 != 0 AND
695 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
701 FROM pg_catalog.pg_statistic fk
702 WHERE staop3 != 0 AND
703 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
708 SELECT ctid, spcowner
709 FROM pg_catalog.pg_tablespace fk
710 WHERE spcowner != 0 AND
711 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.spcowner);
716 SELECT ctid, cfgnamespace
717 FROM pg_catalog.pg_ts_config fk
718 WHERE cfgnamespace != 0 AND
719 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.cfgnamespace);
721 ------+--------------
724 SELECT ctid, cfgowner
725 FROM pg_catalog.pg_ts_config fk
726 WHERE cfgowner != 0 AND
727 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.cfgowner);
732 SELECT ctid, cfgparser
733 FROM pg_catalog.pg_ts_config fk
734 WHERE cfgparser != 0 AND
735 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_parser pk WHERE pk.oid = fk.cfgparser);
741 FROM pg_catalog.pg_ts_config_map fk
742 WHERE mapcfg != 0 AND
743 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_config pk WHERE pk.oid = fk.mapcfg);
749 FROM pg_catalog.pg_ts_config_map fk
750 WHERE mapdict != 0 AND
751 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_dict pk WHERE pk.oid = fk.mapdict);
756 SELECT ctid, dictnamespace
757 FROM pg_catalog.pg_ts_dict fk
758 WHERE dictnamespace != 0 AND
759 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.dictnamespace);
761 ------+---------------
764 SELECT ctid, dictowner
765 FROM pg_catalog.pg_ts_dict fk
766 WHERE dictowner != 0 AND
767 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.dictowner);
772 SELECT ctid, dicttemplate
773 FROM pg_catalog.pg_ts_dict fk
774 WHERE dicttemplate != 0 AND
775 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_template pk WHERE pk.oid = fk.dicttemplate);
777 ------+--------------
780 SELECT ctid, prsnamespace
781 FROM pg_catalog.pg_ts_parser fk
782 WHERE prsnamespace != 0 AND
783 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.prsnamespace);
785 ------+--------------
788 SELECT ctid, prsstart
789 FROM pg_catalog.pg_ts_parser fk
790 WHERE prsstart != 0 AND
791 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsstart);
796 SELECT ctid, prstoken
797 FROM pg_catalog.pg_ts_parser fk
798 WHERE prstoken != 0 AND
799 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prstoken);
805 FROM pg_catalog.pg_ts_parser fk
806 WHERE prsend != 0 AND
807 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsend);
812 SELECT ctid, prsheadline
813 FROM pg_catalog.pg_ts_parser fk
814 WHERE prsheadline != 0 AND
815 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsheadline);
820 SELECT ctid, prslextype
821 FROM pg_catalog.pg_ts_parser fk
822 WHERE prslextype != 0 AND
823 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prslextype);
828 SELECT ctid, tmplnamespace
829 FROM pg_catalog.pg_ts_template fk
830 WHERE tmplnamespace != 0 AND
831 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.tmplnamespace);
833 ------+---------------
836 SELECT ctid, tmplinit
837 FROM pg_catalog.pg_ts_template fk
838 WHERE tmplinit != 0 AND
839 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmplinit);
844 SELECT ctid, tmpllexize
845 FROM pg_catalog.pg_ts_template fk
846 WHERE tmpllexize != 0 AND
847 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmpllexize);
852 SELECT ctid, typnamespace
853 FROM pg_catalog.pg_type fk
854 WHERE typnamespace != 0 AND
855 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
857 ------+--------------
860 SELECT ctid, typowner
861 FROM pg_catalog.pg_type fk
862 WHERE typowner != 0 AND
863 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.typowner);
868 SELECT ctid, typrelid
869 FROM pg_catalog.pg_type fk
870 WHERE typrelid != 0 AND
871 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
877 FROM pg_catalog.pg_type fk
878 WHERE typelem != 0 AND
879 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
884 SELECT ctid, typarray
885 FROM pg_catalog.pg_type fk
886 WHERE typarray != 0 AND
887 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typarray);
892 SELECT ctid, typinput
893 FROM pg_catalog.pg_type fk
894 WHERE typinput != 0 AND
895 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
900 SELECT ctid, typoutput
901 FROM pg_catalog.pg_type fk
902 WHERE typoutput != 0 AND
903 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
908 SELECT ctid, typreceive
909 FROM pg_catalog.pg_type fk
910 WHERE typreceive != 0 AND
911 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
917 FROM pg_catalog.pg_type fk
918 WHERE typsend != 0 AND
919 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
924 SELECT ctid, typmodin
925 FROM pg_catalog.pg_type fk
926 WHERE typmodin != 0 AND
927 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodin);
932 SELECT ctid, typmodout
933 FROM pg_catalog.pg_type fk
934 WHERE typmodout != 0 AND
935 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
940 SELECT ctid, typanalyze
941 FROM pg_catalog.pg_type fk
942 WHERE typanalyze != 0 AND
943 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
948 SELECT ctid, typbasetype
949 FROM pg_catalog.pg_type fk
950 WHERE typbasetype != 0 AND
951 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);