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
------+---------------
381
FROM pg_catalog.pg_depend fk
382
WHERE classid != 0 AND
383
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
388
SELECT ctid, refclassid
389
FROM pg_catalog.pg_depend fk
390
WHERE refclassid != 0 AND
391
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
396
SELECT ctid, classoid
397
FROM pg_catalog.pg_description fk
398
WHERE classoid != 0 AND
399
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
404
SELECT ctid, indexrelid
405
FROM pg_catalog.pg_index fk
406
WHERE indexrelid != 0 AND
407
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
412
SELECT ctid, indrelid
413
FROM pg_catalog.pg_index fk
414
WHERE indrelid != 0 AND
415
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
420
SELECT ctid, lanowner
421
FROM pg_catalog.pg_language fk
422
WHERE lanowner != 0 AND
423
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lanowner);
428
SELECT ctid, lanvalidator
429
FROM pg_catalog.pg_language fk
430
WHERE lanvalidator != 0 AND
431
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
433
------+--------------
436
SELECT ctid, nspowner
437
FROM pg_catalog.pg_namespace fk
438
WHERE nspowner != 0 AND
439
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.nspowner);
444
SELECT ctid, opcmethod
445
FROM pg_catalog.pg_opclass fk
446
WHERE opcmethod != 0 AND
447
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcmethod);
452
SELECT ctid, opcnamespace
453
FROM pg_catalog.pg_opclass fk
454
WHERE opcnamespace != 0 AND
455
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
457
------+--------------
460
SELECT ctid, opcowner
461
FROM pg_catalog.pg_opclass fk
462
WHERE opcowner != 0 AND
463
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opcowner);
468
SELECT ctid, opcfamily
469
FROM pg_catalog.pg_opclass fk
470
WHERE opcfamily != 0 AND
471
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
476
SELECT ctid, opcintype
477
FROM pg_catalog.pg_opclass fk
478
WHERE opcintype != 0 AND
479
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
484
SELECT ctid, opckeytype
485
FROM pg_catalog.pg_opclass fk
486
WHERE opckeytype != 0 AND
487
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opckeytype);
492
SELECT ctid, oprnamespace
493
FROM pg_catalog.pg_operator fk
494
WHERE oprnamespace != 0 AND
495
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
497
------+--------------
500
SELECT ctid, oprowner
501
FROM pg_catalog.pg_operator fk
502
WHERE oprowner != 0 AND
503
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.oprowner);
509
FROM pg_catalog.pg_operator fk
510
WHERE oprleft != 0 AND
511
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
516
SELECT ctid, oprright
517
FROM pg_catalog.pg_operator fk
518
WHERE oprright != 0 AND
519
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
524
SELECT ctid, oprresult
525
FROM pg_catalog.pg_operator fk
526
WHERE oprresult != 0 AND
527
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
533
FROM pg_catalog.pg_operator fk
534
WHERE oprcom != 0 AND
535
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
540
SELECT ctid, oprnegate
541
FROM pg_catalog.pg_operator fk
542
WHERE oprnegate != 0 AND
543
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
549
FROM pg_catalog.pg_operator fk
550
WHERE oprcode != 0 AND
551
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
557
FROM pg_catalog.pg_operator fk
558
WHERE oprrest != 0 AND
559
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
565
FROM pg_catalog.pg_operator fk
566
WHERE oprjoin != 0 AND
567
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
572
SELECT ctid, opfmethod
573
FROM pg_catalog.pg_opfamily fk
574
WHERE opfmethod != 0 AND
575
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opfmethod);
580
SELECT ctid, opfnamespace
581
FROM pg_catalog.pg_opfamily fk
582
WHERE opfnamespace != 0 AND
583
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opfnamespace);
585
------+--------------
588
SELECT ctid, opfowner
589
FROM pg_catalog.pg_opfamily fk
590
WHERE opfowner != 0 AND
591
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opfowner);
596
SELECT ctid, pronamespace
597
FROM pg_catalog.pg_proc fk
598
WHERE pronamespace != 0 AND
599
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
601
------+--------------
604
SELECT ctid, proowner
605
FROM pg_catalog.pg_proc fk
606
WHERE proowner != 0 AND
607
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.proowner);
613
FROM pg_catalog.pg_proc fk
614
WHERE prolang != 0 AND
615
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
620
SELECT ctid, prorettype
621
FROM pg_catalog.pg_proc fk
622
WHERE prorettype != 0 AND
623
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
628
SELECT ctid, ev_class
629
FROM pg_catalog.pg_rewrite fk
630
WHERE ev_class != 0 AND
631
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
636
SELECT ctid, refclassid
637
FROM pg_catalog.pg_shdepend fk
638
WHERE refclassid != 0 AND
639
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
644
SELECT ctid, classoid
645
FROM pg_catalog.pg_shdescription fk
646
WHERE classoid != 0 AND
647
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
652
SELECT ctid, starelid
653
FROM pg_catalog.pg_statistic fk
654
WHERE starelid != 0 AND
655
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
661
FROM pg_catalog.pg_statistic fk
662
WHERE staop1 != 0 AND
663
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
669
FROM pg_catalog.pg_statistic fk
670
WHERE staop2 != 0 AND
671
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
677
FROM pg_catalog.pg_statistic fk
678
WHERE staop3 != 0 AND
679
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
684
SELECT ctid, spcowner
685
FROM pg_catalog.pg_tablespace fk
686
WHERE spcowner != 0 AND
687
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.spcowner);
693
FROM pg_catalog.pg_trigger fk
694
WHERE tgrelid != 0 AND
695
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgrelid);
701
FROM pg_catalog.pg_trigger fk
702
WHERE tgfoid != 0 AND
703
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tgfoid);
708
SELECT ctid, cfgnamespace
709
FROM pg_catalog.pg_ts_config fk
710
WHERE cfgnamespace != 0 AND
711
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.cfgnamespace);
713
------+--------------
716
SELECT ctid, cfgowner
717
FROM pg_catalog.pg_ts_config fk
718
WHERE cfgowner != 0 AND
719
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.cfgowner);
724
SELECT ctid, cfgparser
725
FROM pg_catalog.pg_ts_config fk
726
WHERE cfgparser != 0 AND
727
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_parser pk WHERE pk.oid = fk.cfgparser);
733
FROM pg_catalog.pg_ts_config_map fk
734
WHERE mapcfg != 0 AND
735
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_config pk WHERE pk.oid = fk.mapcfg);
741
FROM pg_catalog.pg_ts_config_map fk
742
WHERE mapdict != 0 AND
743
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_dict pk WHERE pk.oid = fk.mapdict);
748
SELECT ctid, dictnamespace
749
FROM pg_catalog.pg_ts_dict fk
750
WHERE dictnamespace != 0 AND
751
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.dictnamespace);
753
------+---------------
756
SELECT ctid, dictowner
757
FROM pg_catalog.pg_ts_dict fk
758
WHERE dictowner != 0 AND
759
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.dictowner);
764
SELECT ctid, dicttemplate
765
FROM pg_catalog.pg_ts_dict fk
766
WHERE dicttemplate != 0 AND
767
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_template pk WHERE pk.oid = fk.dicttemplate);
769
------+--------------
772
SELECT ctid, prsnamespace
773
FROM pg_catalog.pg_ts_parser fk
774
WHERE prsnamespace != 0 AND
775
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.prsnamespace);
777
------+--------------
780
SELECT ctid, prsstart
781
FROM pg_catalog.pg_ts_parser fk
782
WHERE prsstart != 0 AND
783
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsstart);
788
SELECT ctid, prstoken
789
FROM pg_catalog.pg_ts_parser fk
790
WHERE prstoken != 0 AND
791
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prstoken);
797
FROM pg_catalog.pg_ts_parser fk
798
WHERE prsend != 0 AND
799
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsend);
804
SELECT ctid, prsheadline
805
FROM pg_catalog.pg_ts_parser fk
806
WHERE prsheadline != 0 AND
807
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsheadline);
812
SELECT ctid, prslextype
813
FROM pg_catalog.pg_ts_parser fk
814
WHERE prslextype != 0 AND
815
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prslextype);
820
SELECT ctid, tmplnamespace
821
FROM pg_catalog.pg_ts_template fk
822
WHERE tmplnamespace != 0 AND
823
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.tmplnamespace);
825
------+---------------
828
SELECT ctid, tmplinit
829
FROM pg_catalog.pg_ts_template fk
830
WHERE tmplinit != 0 AND
831
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmplinit);
836
SELECT ctid, tmpllexize
837
FROM pg_catalog.pg_ts_template fk
838
WHERE tmpllexize != 0 AND
839
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmpllexize);
844
SELECT ctid, typnamespace
845
FROM pg_catalog.pg_type fk
846
WHERE typnamespace != 0 AND
847
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
849
------+--------------
852
SELECT ctid, typowner
853
FROM pg_catalog.pg_type fk
854
WHERE typowner != 0 AND
855
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.typowner);
860
SELECT ctid, typrelid
861
FROM pg_catalog.pg_type fk
862
WHERE typrelid != 0 AND
863
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
869
FROM pg_catalog.pg_type fk
870
WHERE typelem != 0 AND
871
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
876
SELECT ctid, typarray
877
FROM pg_catalog.pg_type fk
878
WHERE typarray != 0 AND
879
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typarray);
884
SELECT ctid, typinput
885
FROM pg_catalog.pg_type fk
886
WHERE typinput != 0 AND
887
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
892
SELECT ctid, typoutput
893
FROM pg_catalog.pg_type fk
894
WHERE typoutput != 0 AND
895
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
900
SELECT ctid, typreceive
901
FROM pg_catalog.pg_type fk
902
WHERE typreceive != 0 AND
903
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
909
FROM pg_catalog.pg_type fk
910
WHERE typsend != 0 AND
911
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
916
SELECT ctid, typmodin
917
FROM pg_catalog.pg_type fk
918
WHERE typmodin != 0 AND
919
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodin);
924
SELECT ctid, typmodout
925
FROM pg_catalog.pg_type fk
926
WHERE typmodout != 0 AND
927
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
932
SELECT ctid, typanalyze
933
FROM pg_catalog.pg_type fk
934
WHERE typanalyze != 0 AND
935
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
940
SELECT ctid, typbasetype
941
FROM pg_catalog.pg_type fk
942
WHERE typbasetype != 0 AND
943
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);