1--
2-- This is created by pgsql/src/tools/findoidjoins/make_oidjoins_check
3--
4SELECT	ctid, aggfnoid
5FROM	pg_catalog.pg_aggregate fk
6WHERE	aggfnoid != 0 AND
7	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfnoid);
8 ctid | aggfnoid
9------+----------
10(0 rows)
11
12SELECT	ctid, aggtransfn
13FROM	pg_catalog.pg_aggregate fk
14WHERE	aggtransfn != 0 AND
15	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggtransfn);
16 ctid | aggtransfn
17------+------------
18(0 rows)
19
20SELECT	ctid, aggfinalfn
21FROM	pg_catalog.pg_aggregate fk
22WHERE	aggfinalfn != 0 AND
23	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfinalfn);
24 ctid | aggfinalfn
25------+------------
26(0 rows)
27
28SELECT	ctid, aggcombinefn
29FROM	pg_catalog.pg_aggregate fk
30WHERE	aggcombinefn != 0 AND
31	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggcombinefn);
32 ctid | aggcombinefn
33------+--------------
34(0 rows)
35
36SELECT	ctid, aggserialfn
37FROM	pg_catalog.pg_aggregate fk
38WHERE	aggserialfn != 0 AND
39	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggserialfn);
40 ctid | aggserialfn
41------+-------------
42(0 rows)
43
44SELECT	ctid, aggdeserialfn
45FROM	pg_catalog.pg_aggregate fk
46WHERE	aggdeserialfn != 0 AND
47	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggdeserialfn);
48 ctid | aggdeserialfn
49------+---------------
50(0 rows)
51
52SELECT	ctid, aggmtransfn
53FROM	pg_catalog.pg_aggregate fk
54WHERE	aggmtransfn != 0 AND
55	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggmtransfn);
56 ctid | aggmtransfn
57------+-------------
58(0 rows)
59
60SELECT	ctid, aggminvtransfn
61FROM	pg_catalog.pg_aggregate fk
62WHERE	aggminvtransfn != 0 AND
63	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggminvtransfn);
64 ctid | aggminvtransfn
65------+----------------
66(0 rows)
67
68SELECT	ctid, aggmfinalfn
69FROM	pg_catalog.pg_aggregate fk
70WHERE	aggmfinalfn != 0 AND
71	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggmfinalfn);
72 ctid | aggmfinalfn
73------+-------------
74(0 rows)
75
76SELECT	ctid, aggsortop
77FROM	pg_catalog.pg_aggregate fk
78WHERE	aggsortop != 0 AND
79	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.aggsortop);
80 ctid | aggsortop
81------+-----------
82(0 rows)
83
84SELECT	ctid, aggtranstype
85FROM	pg_catalog.pg_aggregate fk
86WHERE	aggtranstype != 0 AND
87	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
88 ctid | aggtranstype
89------+--------------
90(0 rows)
91
92SELECT	ctid, aggmtranstype
93FROM	pg_catalog.pg_aggregate fk
94WHERE	aggmtranstype != 0 AND
95	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggmtranstype);
96 ctid | aggmtranstype
97------+---------------
98(0 rows)
99
100SELECT	ctid, amhandler
101FROM	pg_catalog.pg_am fk
102WHERE	amhandler != 0 AND
103	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amhandler);
104 ctid | amhandler
105------+-----------
106(0 rows)
107
108SELECT	ctid, amopfamily
109FROM	pg_catalog.pg_amop fk
110WHERE	amopfamily != 0 AND
111	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amopfamily);
112 ctid | amopfamily
113------+------------
114(0 rows)
115
116SELECT	ctid, amoplefttype
117FROM	pg_catalog.pg_amop fk
118WHERE	amoplefttype != 0 AND
119	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoplefttype);
120 ctid | amoplefttype
121------+--------------
122(0 rows)
123
124SELECT	ctid, amoprighttype
125FROM	pg_catalog.pg_amop fk
126WHERE	amoprighttype != 0 AND
127	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoprighttype);
128 ctid | amoprighttype
129------+---------------
130(0 rows)
131
132SELECT	ctid, amopopr
133FROM	pg_catalog.pg_amop fk
134WHERE	amopopr != 0 AND
135	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.amopopr);
136 ctid | amopopr
137------+---------
138(0 rows)
139
140SELECT	ctid, amopmethod
141FROM	pg_catalog.pg_amop fk
142WHERE	amopmethod != 0 AND
143	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.amopmethod);
144 ctid | amopmethod
145------+------------
146(0 rows)
147
148SELECT	ctid, amopsortfamily
149FROM	pg_catalog.pg_amop fk
150WHERE	amopsortfamily != 0 AND
151	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amopsortfamily);
152 ctid | amopsortfamily
153------+----------------
154(0 rows)
155
156SELECT	ctid, amprocfamily
157FROM	pg_catalog.pg_amproc fk
158WHERE	amprocfamily != 0 AND
159	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amprocfamily);
160 ctid | amprocfamily
161------+--------------
162(0 rows)
163
164SELECT	ctid, amproclefttype
165FROM	pg_catalog.pg_amproc fk
166WHERE	amproclefttype != 0 AND
167	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amproclefttype);
168 ctid | amproclefttype
169------+----------------
170(0 rows)
171
172SELECT	ctid, amprocrighttype
173FROM	pg_catalog.pg_amproc fk
174WHERE	amprocrighttype != 0 AND
175	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocrighttype);
176 ctid | amprocrighttype
177------+-----------------
178(0 rows)
179
180SELECT	ctid, amproc
181FROM	pg_catalog.pg_amproc fk
182WHERE	amproc != 0 AND
183	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
184 ctid | amproc
185------+--------
186(0 rows)
187
188SELECT	ctid, adrelid
189FROM	pg_catalog.pg_attrdef fk
190WHERE	adrelid != 0 AND
191	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.adrelid);
192 ctid | adrelid
193------+---------
194(0 rows)
195
196SELECT	ctid, attrelid
197FROM	pg_catalog.pg_attribute fk
198WHERE	attrelid != 0 AND
199	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.attrelid);
200 ctid | attrelid
201------+----------
202(0 rows)
203
204SELECT	ctid, atttypid
205FROM	pg_catalog.pg_attribute fk
206WHERE	atttypid != 0 AND
207	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.atttypid);
208 ctid | atttypid
209------+----------
210(0 rows)
211
212SELECT	ctid, attcollation
213FROM	pg_catalog.pg_attribute fk
214WHERE	attcollation != 0 AND
215	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_collation pk WHERE pk.oid = fk.attcollation);
216 ctid | attcollation
217------+--------------
218(0 rows)
219
220SELECT	ctid, roleid
221FROM	pg_catalog.pg_auth_members fk
222WHERE	roleid != 0 AND
223	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.roleid);
224 ctid | roleid
225------+--------
226(0 rows)
227
228SELECT	ctid, member
229FROM	pg_catalog.pg_auth_members fk
230WHERE	member != 0 AND
231	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.member);
232 ctid | member
233------+--------
234(0 rows)
235
236SELECT	ctid, grantor
237FROM	pg_catalog.pg_auth_members fk
238WHERE	grantor != 0 AND
239	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.grantor);
240 ctid | grantor
241------+---------
242(0 rows)
243
244SELECT	ctid, castsource
245FROM	pg_catalog.pg_cast fk
246WHERE	castsource != 0 AND
247	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.castsource);
248 ctid | castsource
249------+------------
250(0 rows)
251
252SELECT	ctid, casttarget
253FROM	pg_catalog.pg_cast fk
254WHERE	casttarget != 0 AND
255	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.casttarget);
256 ctid | casttarget
257------+------------
258(0 rows)
259
260SELECT	ctid, castfunc
261FROM	pg_catalog.pg_cast fk
262WHERE	castfunc != 0 AND
263	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.castfunc);
264 ctid | castfunc
265------+----------
266(0 rows)
267
268SELECT	ctid, relnamespace
269FROM	pg_catalog.pg_class fk
270WHERE	relnamespace != 0 AND
271	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.relnamespace);
272 ctid | relnamespace
273------+--------------
274(0 rows)
275
276SELECT	ctid, reltype
277FROM	pg_catalog.pg_class fk
278WHERE	reltype != 0 AND
279	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reltype);
280 ctid | reltype
281------+---------
282(0 rows)
283
284SELECT	ctid, reloftype
285FROM	pg_catalog.pg_class fk
286WHERE	reloftype != 0 AND
287	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reloftype);
288 ctid | reloftype
289------+-----------
290(0 rows)
291
292SELECT	ctid, relowner
293FROM	pg_catalog.pg_class fk
294WHERE	relowner != 0 AND
295	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.relowner);
296 ctid | relowner
297------+----------
298(0 rows)
299
300SELECT	ctid, relam
301FROM	pg_catalog.pg_class fk
302WHERE	relam != 0 AND
303	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam);
304 ctid | relam
305------+-------
306(0 rows)
307
308SELECT	ctid, reltablespace
309FROM	pg_catalog.pg_class fk
310WHERE	reltablespace != 0 AND
311	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace);
312 ctid | reltablespace
313------+---------------
314(0 rows)
315
316SELECT	ctid, reltoastrelid
317FROM	pg_catalog.pg_class fk
318WHERE	reltoastrelid != 0 AND
319	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
320 ctid | reltoastrelid
321------+---------------
322(0 rows)
323
324SELECT	ctid, collnamespace
325FROM	pg_catalog.pg_collation fk
326WHERE	collnamespace != 0 AND
327	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.collnamespace);
328 ctid | collnamespace
329------+---------------
330(0 rows)
331
332SELECT	ctid, collowner
333FROM	pg_catalog.pg_collation fk
334WHERE	collowner != 0 AND
335	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.collowner);
336 ctid | collowner
337------+-----------
338(0 rows)
339
340SELECT	ctid, connamespace
341FROM	pg_catalog.pg_constraint fk
342WHERE	connamespace != 0 AND
343	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
344 ctid | connamespace
345------+--------------
346(0 rows)
347
348SELECT	ctid, conrelid
349FROM	pg_catalog.pg_constraint fk
350WHERE	conrelid != 0 AND
351	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.conrelid);
352 ctid | conrelid
353------+----------
354(0 rows)
355
356SELECT	ctid, contypid
357FROM	pg_catalog.pg_constraint fk
358WHERE	contypid != 0 AND
359	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
360 ctid | contypid
361------+----------
362(0 rows)
363
364SELECT	ctid, conindid
365FROM	pg_catalog.pg_constraint fk
366WHERE	conindid != 0 AND
367	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.conindid);
368 ctid | conindid
369------+----------
370(0 rows)
371
372SELECT	ctid, confrelid
373FROM	pg_catalog.pg_constraint fk
374WHERE	confrelid != 0 AND
375	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.confrelid);
376 ctid | confrelid
377------+-----------
378(0 rows)
379
380SELECT	ctid, connamespace
381FROM	pg_catalog.pg_conversion fk
382WHERE	connamespace != 0 AND
383	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
384 ctid | connamespace
385------+--------------
386(0 rows)
387
388SELECT	ctid, conowner
389FROM	pg_catalog.pg_conversion fk
390WHERE	conowner != 0 AND
391	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.conowner);
392 ctid | conowner
393------+----------
394(0 rows)
395
396SELECT	ctid, conproc
397FROM	pg_catalog.pg_conversion fk
398WHERE	conproc != 0 AND
399	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
400 ctid | conproc
401------+---------
402(0 rows)
403
404SELECT	ctid, datdba
405FROM	pg_catalog.pg_database fk
406WHERE	datdba != 0 AND
407	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.datdba);
408 ctid | datdba
409------+--------
410(0 rows)
411
412SELECT	ctid, dattablespace
413FROM	pg_catalog.pg_database fk
414WHERE	dattablespace != 0 AND
415	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace);
416 ctid | dattablespace
417------+---------------
418(0 rows)
419
420SELECT	ctid, setdatabase
421FROM	pg_catalog.pg_db_role_setting fk
422WHERE	setdatabase != 0 AND
423	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_database pk WHERE pk.oid = fk.setdatabase);
424 ctid | setdatabase
425------+-------------
426(0 rows)
427
428SELECT	ctid, classid
429FROM	pg_catalog.pg_depend fk
430WHERE	classid != 0 AND
431	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
432 ctid | classid
433------+---------
434(0 rows)
435
436SELECT	ctid, refclassid
437FROM	pg_catalog.pg_depend fk
438WHERE	refclassid != 0 AND
439	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
440 ctid | refclassid
441------+------------
442(0 rows)
443
444SELECT	ctid, classoid
445FROM	pg_catalog.pg_description fk
446WHERE	classoid != 0 AND
447	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
448 ctid | classoid
449------+----------
450(0 rows)
451
452SELECT	ctid, enumtypid
453FROM	pg_catalog.pg_enum fk
454WHERE	enumtypid != 0 AND
455	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.enumtypid);
456 ctid | enumtypid
457------+-----------
458(0 rows)
459
460SELECT	ctid, extowner
461FROM	pg_catalog.pg_extension fk
462WHERE	extowner != 0 AND
463	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.extowner);
464 ctid | extowner
465------+----------
466(0 rows)
467
468SELECT	ctid, extnamespace
469FROM	pg_catalog.pg_extension fk
470WHERE	extnamespace != 0 AND
471	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.extnamespace);
472 ctid | extnamespace
473------+--------------
474(0 rows)
475
476SELECT	ctid, fdwowner
477FROM	pg_catalog.pg_foreign_data_wrapper fk
478WHERE	fdwowner != 0 AND
479	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.fdwowner);
480 ctid | fdwowner
481------+----------
482(0 rows)
483
484SELECT	ctid, srvowner
485FROM	pg_catalog.pg_foreign_server fk
486WHERE	srvowner != 0 AND
487	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.srvowner);
488 ctid | srvowner
489------+----------
490(0 rows)
491
492SELECT	ctid, srvfdw
493FROM	pg_catalog.pg_foreign_server fk
494WHERE	srvfdw != 0 AND
495	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_foreign_data_wrapper pk WHERE pk.oid = fk.srvfdw);
496 ctid | srvfdw
497------+--------
498(0 rows)
499
500SELECT	ctid, indexrelid
501FROM	pg_catalog.pg_index fk
502WHERE	indexrelid != 0 AND
503	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
504 ctid | indexrelid
505------+------------
506(0 rows)
507
508SELECT	ctid, indrelid
509FROM	pg_catalog.pg_index fk
510WHERE	indrelid != 0 AND
511	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
512 ctid | indrelid
513------+----------
514(0 rows)
515
516SELECT	ctid, inhrelid
517FROM	pg_catalog.pg_inherits fk
518WHERE	inhrelid != 0 AND
519	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.inhrelid);
520 ctid | inhrelid
521------+----------
522(0 rows)
523
524SELECT	ctid, inhparent
525FROM	pg_catalog.pg_inherits fk
526WHERE	inhparent != 0 AND
527	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.inhparent);
528 ctid | inhparent
529------+-----------
530(0 rows)
531
532SELECT	ctid, classoid
533FROM	pg_catalog.pg_init_privs fk
534WHERE	classoid != 0 AND
535	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
536 ctid | classoid
537------+----------
538(0 rows)
539
540SELECT	ctid, lanowner
541FROM	pg_catalog.pg_language fk
542WHERE	lanowner != 0 AND
543	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lanowner);
544 ctid | lanowner
545------+----------
546(0 rows)
547
548SELECT	ctid, lanplcallfoid
549FROM	pg_catalog.pg_language fk
550WHERE	lanplcallfoid != 0 AND
551	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanplcallfoid);
552 ctid | lanplcallfoid
553------+---------------
554(0 rows)
555
556SELECT	ctid, laninline
557FROM	pg_catalog.pg_language fk
558WHERE	laninline != 0 AND
559	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.laninline);
560 ctid | laninline
561------+-----------
562(0 rows)
563
564SELECT	ctid, lanvalidator
565FROM	pg_catalog.pg_language fk
566WHERE	lanvalidator != 0 AND
567	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
568 ctid | lanvalidator
569------+--------------
570(0 rows)
571
572SELECT	ctid, loid
573FROM	pg_catalog.pg_largeobject fk
574WHERE	loid != 0 AND
575	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_largeobject_metadata pk WHERE pk.oid = fk.loid);
576 ctid | loid
577------+------
578(0 rows)
579
580SELECT	ctid, lomowner
581FROM	pg_catalog.pg_largeobject_metadata fk
582WHERE	lomowner != 0 AND
583	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lomowner);
584 ctid | lomowner
585------+----------
586(0 rows)
587
588SELECT	ctid, nspowner
589FROM	pg_catalog.pg_namespace fk
590WHERE	nspowner != 0 AND
591	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.nspowner);
592 ctid | nspowner
593------+----------
594(0 rows)
595
596SELECT	ctid, opcmethod
597FROM	pg_catalog.pg_opclass fk
598WHERE	opcmethod != 0 AND
599	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcmethod);
600 ctid | opcmethod
601------+-----------
602(0 rows)
603
604SELECT	ctid, opcnamespace
605FROM	pg_catalog.pg_opclass fk
606WHERE	opcnamespace != 0 AND
607	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
608 ctid | opcnamespace
609------+--------------
610(0 rows)
611
612SELECT	ctid, opcowner
613FROM	pg_catalog.pg_opclass fk
614WHERE	opcowner != 0 AND
615	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opcowner);
616 ctid | opcowner
617------+----------
618(0 rows)
619
620SELECT	ctid, opcfamily
621FROM	pg_catalog.pg_opclass fk
622WHERE	opcfamily != 0 AND
623	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
624 ctid | opcfamily
625------+-----------
626(0 rows)
627
628SELECT	ctid, opcintype
629FROM	pg_catalog.pg_opclass fk
630WHERE	opcintype != 0 AND
631	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
632 ctid | opcintype
633------+-----------
634(0 rows)
635
636SELECT	ctid, opckeytype
637FROM	pg_catalog.pg_opclass fk
638WHERE	opckeytype != 0 AND
639	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opckeytype);
640 ctid | opckeytype
641------+------------
642(0 rows)
643
644SELECT	ctid, oprnamespace
645FROM	pg_catalog.pg_operator fk
646WHERE	oprnamespace != 0 AND
647	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
648 ctid | oprnamespace
649------+--------------
650(0 rows)
651
652SELECT	ctid, oprowner
653FROM	pg_catalog.pg_operator fk
654WHERE	oprowner != 0 AND
655	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.oprowner);
656 ctid | oprowner
657------+----------
658(0 rows)
659
660SELECT	ctid, oprleft
661FROM	pg_catalog.pg_operator fk
662WHERE	oprleft != 0 AND
663	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
664 ctid | oprleft
665------+---------
666(0 rows)
667
668SELECT	ctid, oprright
669FROM	pg_catalog.pg_operator fk
670WHERE	oprright != 0 AND
671	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
672 ctid | oprright
673------+----------
674(0 rows)
675
676SELECT	ctid, oprresult
677FROM	pg_catalog.pg_operator fk
678WHERE	oprresult != 0 AND
679	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
680 ctid | oprresult
681------+-----------
682(0 rows)
683
684SELECT	ctid, oprcom
685FROM	pg_catalog.pg_operator fk
686WHERE	oprcom != 0 AND
687	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
688 ctid | oprcom
689------+--------
690(0 rows)
691
692SELECT	ctid, oprnegate
693FROM	pg_catalog.pg_operator fk
694WHERE	oprnegate != 0 AND
695	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
696 ctid | oprnegate
697------+-----------
698(0 rows)
699
700SELECT	ctid, oprcode
701FROM	pg_catalog.pg_operator fk
702WHERE	oprcode != 0 AND
703	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
704 ctid | oprcode
705------+---------
706(0 rows)
707
708SELECT	ctid, oprrest
709FROM	pg_catalog.pg_operator fk
710WHERE	oprrest != 0 AND
711	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
712 ctid | oprrest
713------+---------
714(0 rows)
715
716SELECT	ctid, oprjoin
717FROM	pg_catalog.pg_operator fk
718WHERE	oprjoin != 0 AND
719	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
720 ctid | oprjoin
721------+---------
722(0 rows)
723
724SELECT	ctid, opfmethod
725FROM	pg_catalog.pg_opfamily fk
726WHERE	opfmethod != 0 AND
727	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opfmethod);
728 ctid | opfmethod
729------+-----------
730(0 rows)
731
732SELECT	ctid, opfnamespace
733FROM	pg_catalog.pg_opfamily fk
734WHERE	opfnamespace != 0 AND
735	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opfnamespace);
736 ctid | opfnamespace
737------+--------------
738(0 rows)
739
740SELECT	ctid, opfowner
741FROM	pg_catalog.pg_opfamily fk
742WHERE	opfowner != 0 AND
743	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opfowner);
744 ctid | opfowner
745------+----------
746(0 rows)
747
748SELECT	ctid, partrelid
749FROM	pg_catalog.pg_partitioned_table fk
750WHERE	partrelid != 0 AND
751	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.partrelid);
752 ctid | partrelid
753------+-----------
754(0 rows)
755
756SELECT	ctid, polrelid
757FROM	pg_catalog.pg_policy fk
758WHERE	polrelid != 0 AND
759	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.polrelid);
760 ctid | polrelid
761------+----------
762(0 rows)
763
764SELECT	ctid, pronamespace
765FROM	pg_catalog.pg_proc fk
766WHERE	pronamespace != 0 AND
767	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
768 ctid | pronamespace
769------+--------------
770(0 rows)
771
772SELECT	ctid, proowner
773FROM	pg_catalog.pg_proc fk
774WHERE	proowner != 0 AND
775	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.proowner);
776 ctid | proowner
777------+----------
778(0 rows)
779
780SELECT	ctid, prolang
781FROM	pg_catalog.pg_proc fk
782WHERE	prolang != 0 AND
783	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
784 ctid | prolang
785------+---------
786(0 rows)
787
788SELECT	ctid, provariadic
789FROM	pg_catalog.pg_proc fk
790WHERE	provariadic != 0 AND
791	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.provariadic);
792 ctid | provariadic
793------+-------------
794(0 rows)
795
796SELECT	ctid, protransform
797FROM	pg_catalog.pg_proc fk
798WHERE	protransform != 0 AND
799	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.protransform);
800 ctid | protransform
801------+--------------
802(0 rows)
803
804SELECT	ctid, prorettype
805FROM	pg_catalog.pg_proc fk
806WHERE	prorettype != 0 AND
807	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
808 ctid | prorettype
809------+------------
810(0 rows)
811
812SELECT	ctid, rngtypid
813FROM	pg_catalog.pg_range fk
814WHERE	rngtypid != 0 AND
815	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.rngtypid);
816 ctid | rngtypid
817------+----------
818(0 rows)
819
820SELECT	ctid, rngsubtype
821FROM	pg_catalog.pg_range fk
822WHERE	rngsubtype != 0 AND
823	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.rngsubtype);
824 ctid | rngsubtype
825------+------------
826(0 rows)
827
828SELECT	ctid, rngcollation
829FROM	pg_catalog.pg_range fk
830WHERE	rngcollation != 0 AND
831	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_collation pk WHERE pk.oid = fk.rngcollation);
832 ctid | rngcollation
833------+--------------
834(0 rows)
835
836SELECT	ctid, rngsubopc
837FROM	pg_catalog.pg_range fk
838WHERE	rngsubopc != 0 AND
839	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.rngsubopc);
840 ctid | rngsubopc
841------+-----------
842(0 rows)
843
844SELECT	ctid, rngcanonical
845FROM	pg_catalog.pg_range fk
846WHERE	rngcanonical != 0 AND
847	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.rngcanonical);
848 ctid | rngcanonical
849------+--------------
850(0 rows)
851
852SELECT	ctid, rngsubdiff
853FROM	pg_catalog.pg_range fk
854WHERE	rngsubdiff != 0 AND
855	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.rngsubdiff);
856 ctid | rngsubdiff
857------+------------
858(0 rows)
859
860SELECT	ctid, ev_class
861FROM	pg_catalog.pg_rewrite fk
862WHERE	ev_class != 0 AND
863	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
864 ctid | ev_class
865------+----------
866(0 rows)
867
868SELECT	ctid, seqrelid
869FROM	pg_catalog.pg_sequence fk
870WHERE	seqrelid != 0 AND
871	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.seqrelid);
872 ctid | seqrelid
873------+----------
874(0 rows)
875
876SELECT	ctid, seqtypid
877FROM	pg_catalog.pg_sequence fk
878WHERE	seqtypid != 0 AND
879	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.seqtypid);
880 ctid | seqtypid
881------+----------
882(0 rows)
883
884SELECT	ctid, refclassid
885FROM	pg_catalog.pg_shdepend fk
886WHERE	refclassid != 0 AND
887	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
888 ctid | refclassid
889------+------------
890(0 rows)
891
892SELECT	ctid, classoid
893FROM	pg_catalog.pg_shdescription fk
894WHERE	classoid != 0 AND
895	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
896 ctid | classoid
897------+----------
898(0 rows)
899
900SELECT	ctid, starelid
901FROM	pg_catalog.pg_statistic fk
902WHERE	starelid != 0 AND
903	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
904 ctid | starelid
905------+----------
906(0 rows)
907
908SELECT	ctid, staop1
909FROM	pg_catalog.pg_statistic fk
910WHERE	staop1 != 0 AND
911	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
912 ctid | staop1
913------+--------
914(0 rows)
915
916SELECT	ctid, staop2
917FROM	pg_catalog.pg_statistic fk
918WHERE	staop2 != 0 AND
919	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
920 ctid | staop2
921------+--------
922(0 rows)
923
924SELECT	ctid, staop3
925FROM	pg_catalog.pg_statistic fk
926WHERE	staop3 != 0 AND
927	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
928 ctid | staop3
929------+--------
930(0 rows)
931
932SELECT	ctid, staop4
933FROM	pg_catalog.pg_statistic fk
934WHERE	staop4 != 0 AND
935	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop4);
936 ctid | staop4
937------+--------
938(0 rows)
939
940SELECT	ctid, staop5
941FROM	pg_catalog.pg_statistic fk
942WHERE	staop5 != 0 AND
943	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop5);
944 ctid | staop5
945------+--------
946(0 rows)
947
948SELECT	ctid, stxrelid
949FROM	pg_catalog.pg_statistic_ext fk
950WHERE	stxrelid != 0 AND
951	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.stxrelid);
952 ctid | stxrelid
953------+----------
954(0 rows)
955
956SELECT	ctid, stxnamespace
957FROM	pg_catalog.pg_statistic_ext fk
958WHERE	stxnamespace != 0 AND
959	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.stxnamespace);
960 ctid | stxnamespace
961------+--------------
962(0 rows)
963
964SELECT	ctid, stxowner
965FROM	pg_catalog.pg_statistic_ext fk
966WHERE	stxowner != 0 AND
967	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.stxowner);
968 ctid | stxowner
969------+----------
970(0 rows)
971
972SELECT	ctid, spcowner
973FROM	pg_catalog.pg_tablespace fk
974WHERE	spcowner != 0 AND
975	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.spcowner);
976 ctid | spcowner
977------+----------
978(0 rows)
979
980SELECT	ctid, trftype
981FROM	pg_catalog.pg_transform fk
982WHERE	trftype != 0 AND
983	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.trftype);
984 ctid | trftype
985------+---------
986(0 rows)
987
988SELECT	ctid, trflang
989FROM	pg_catalog.pg_transform fk
990WHERE	trflang != 0 AND
991	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.trflang);
992 ctid | trflang
993------+---------
994(0 rows)
995
996SELECT	ctid, trffromsql
997FROM	pg_catalog.pg_transform fk
998WHERE	trffromsql != 0 AND
999	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trffromsql);
1000 ctid | trffromsql
1001------+------------
1002(0 rows)
1003
1004SELECT	ctid, trftosql
1005FROM	pg_catalog.pg_transform fk
1006WHERE	trftosql != 0 AND
1007	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.trftosql);
1008 ctid | trftosql
1009------+----------
1010(0 rows)
1011
1012SELECT	ctid, tgrelid
1013FROM	pg_catalog.pg_trigger fk
1014WHERE	tgrelid != 0 AND
1015	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgrelid);
1016 ctid | tgrelid
1017------+---------
1018(0 rows)
1019
1020SELECT	ctid, tgfoid
1021FROM	pg_catalog.pg_trigger fk
1022WHERE	tgfoid != 0 AND
1023	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tgfoid);
1024 ctid | tgfoid
1025------+--------
1026(0 rows)
1027
1028SELECT	ctid, tgconstrrelid
1029FROM	pg_catalog.pg_trigger fk
1030WHERE	tgconstrrelid != 0 AND
1031	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgconstrrelid);
1032 ctid | tgconstrrelid
1033------+---------------
1034(0 rows)
1035
1036SELECT	ctid, tgconstrindid
1037FROM	pg_catalog.pg_trigger fk
1038WHERE	tgconstrindid != 0 AND
1039	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgconstrindid);
1040 ctid | tgconstrindid
1041------+---------------
1042(0 rows)
1043
1044SELECT	ctid, tgconstraint
1045FROM	pg_catalog.pg_trigger fk
1046WHERE	tgconstraint != 0 AND
1047	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_constraint pk WHERE pk.oid = fk.tgconstraint);
1048 ctid | tgconstraint
1049------+--------------
1050(0 rows)
1051
1052SELECT	ctid, cfgnamespace
1053FROM	pg_catalog.pg_ts_config fk
1054WHERE	cfgnamespace != 0 AND
1055	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.cfgnamespace);
1056 ctid | cfgnamespace
1057------+--------------
1058(0 rows)
1059
1060SELECT	ctid, cfgowner
1061FROM	pg_catalog.pg_ts_config fk
1062WHERE	cfgowner != 0 AND
1063	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.cfgowner);
1064 ctid | cfgowner
1065------+----------
1066(0 rows)
1067
1068SELECT	ctid, cfgparser
1069FROM	pg_catalog.pg_ts_config fk
1070WHERE	cfgparser != 0 AND
1071	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_parser pk WHERE pk.oid = fk.cfgparser);
1072 ctid | cfgparser
1073------+-----------
1074(0 rows)
1075
1076SELECT	ctid, mapcfg
1077FROM	pg_catalog.pg_ts_config_map fk
1078WHERE	mapcfg != 0 AND
1079	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_config pk WHERE pk.oid = fk.mapcfg);
1080 ctid | mapcfg
1081------+--------
1082(0 rows)
1083
1084SELECT	ctid, mapdict
1085FROM	pg_catalog.pg_ts_config_map fk
1086WHERE	mapdict != 0 AND
1087	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_dict pk WHERE pk.oid = fk.mapdict);
1088 ctid | mapdict
1089------+---------
1090(0 rows)
1091
1092SELECT	ctid, dictnamespace
1093FROM	pg_catalog.pg_ts_dict fk
1094WHERE	dictnamespace != 0 AND
1095	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.dictnamespace);
1096 ctid | dictnamespace
1097------+---------------
1098(0 rows)
1099
1100SELECT	ctid, dictowner
1101FROM	pg_catalog.pg_ts_dict fk
1102WHERE	dictowner != 0 AND
1103	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.dictowner);
1104 ctid | dictowner
1105------+-----------
1106(0 rows)
1107
1108SELECT	ctid, dicttemplate
1109FROM	pg_catalog.pg_ts_dict fk
1110WHERE	dicttemplate != 0 AND
1111	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_template pk WHERE pk.oid = fk.dicttemplate);
1112 ctid | dicttemplate
1113------+--------------
1114(0 rows)
1115
1116SELECT	ctid, prsnamespace
1117FROM	pg_catalog.pg_ts_parser fk
1118WHERE	prsnamespace != 0 AND
1119	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.prsnamespace);
1120 ctid | prsnamespace
1121------+--------------
1122(0 rows)
1123
1124SELECT	ctid, prsstart
1125FROM	pg_catalog.pg_ts_parser fk
1126WHERE	prsstart != 0 AND
1127	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsstart);
1128 ctid | prsstart
1129------+----------
1130(0 rows)
1131
1132SELECT	ctid, prstoken
1133FROM	pg_catalog.pg_ts_parser fk
1134WHERE	prstoken != 0 AND
1135	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prstoken);
1136 ctid | prstoken
1137------+----------
1138(0 rows)
1139
1140SELECT	ctid, prsend
1141FROM	pg_catalog.pg_ts_parser fk
1142WHERE	prsend != 0 AND
1143	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsend);
1144 ctid | prsend
1145------+--------
1146(0 rows)
1147
1148SELECT	ctid, prsheadline
1149FROM	pg_catalog.pg_ts_parser fk
1150WHERE	prsheadline != 0 AND
1151	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsheadline);
1152 ctid | prsheadline
1153------+-------------
1154(0 rows)
1155
1156SELECT	ctid, prslextype
1157FROM	pg_catalog.pg_ts_parser fk
1158WHERE	prslextype != 0 AND
1159	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prslextype);
1160 ctid | prslextype
1161------+------------
1162(0 rows)
1163
1164SELECT	ctid, tmplnamespace
1165FROM	pg_catalog.pg_ts_template fk
1166WHERE	tmplnamespace != 0 AND
1167	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.tmplnamespace);
1168 ctid | tmplnamespace
1169------+---------------
1170(0 rows)
1171
1172SELECT	ctid, tmplinit
1173FROM	pg_catalog.pg_ts_template fk
1174WHERE	tmplinit != 0 AND
1175	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmplinit);
1176 ctid | tmplinit
1177------+----------
1178(0 rows)
1179
1180SELECT	ctid, tmpllexize
1181FROM	pg_catalog.pg_ts_template fk
1182WHERE	tmpllexize != 0 AND
1183	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmpllexize);
1184 ctid | tmpllexize
1185------+------------
1186(0 rows)
1187
1188SELECT	ctid, typnamespace
1189FROM	pg_catalog.pg_type fk
1190WHERE	typnamespace != 0 AND
1191	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
1192 ctid | typnamespace
1193------+--------------
1194(0 rows)
1195
1196SELECT	ctid, typowner
1197FROM	pg_catalog.pg_type fk
1198WHERE	typowner != 0 AND
1199	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.typowner);
1200 ctid | typowner
1201------+----------
1202(0 rows)
1203
1204SELECT	ctid, typrelid
1205FROM	pg_catalog.pg_type fk
1206WHERE	typrelid != 0 AND
1207	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
1208 ctid | typrelid
1209------+----------
1210(0 rows)
1211
1212SELECT	ctid, typelem
1213FROM	pg_catalog.pg_type fk
1214WHERE	typelem != 0 AND
1215	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
1216 ctid | typelem
1217------+---------
1218(0 rows)
1219
1220SELECT	ctid, typarray
1221FROM	pg_catalog.pg_type fk
1222WHERE	typarray != 0 AND
1223	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typarray);
1224 ctid | typarray
1225------+----------
1226(0 rows)
1227
1228SELECT	ctid, typinput
1229FROM	pg_catalog.pg_type fk
1230WHERE	typinput != 0 AND
1231	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
1232 ctid | typinput
1233------+----------
1234(0 rows)
1235
1236SELECT	ctid, typoutput
1237FROM	pg_catalog.pg_type fk
1238WHERE	typoutput != 0 AND
1239	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
1240 ctid | typoutput
1241------+-----------
1242(0 rows)
1243
1244SELECT	ctid, typreceive
1245FROM	pg_catalog.pg_type fk
1246WHERE	typreceive != 0 AND
1247	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
1248 ctid | typreceive
1249------+------------
1250(0 rows)
1251
1252SELECT	ctid, typsend
1253FROM	pg_catalog.pg_type fk
1254WHERE	typsend != 0 AND
1255	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
1256 ctid | typsend
1257------+---------
1258(0 rows)
1259
1260SELECT	ctid, typmodin
1261FROM	pg_catalog.pg_type fk
1262WHERE	typmodin != 0 AND
1263	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodin);
1264 ctid | typmodin
1265------+----------
1266(0 rows)
1267
1268SELECT	ctid, typmodout
1269FROM	pg_catalog.pg_type fk
1270WHERE	typmodout != 0 AND
1271	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
1272 ctid | typmodout
1273------+-----------
1274(0 rows)
1275
1276SELECT	ctid, typanalyze
1277FROM	pg_catalog.pg_type fk
1278WHERE	typanalyze != 0 AND
1279	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
1280 ctid | typanalyze
1281------+------------
1282(0 rows)
1283
1284SELECT	ctid, typbasetype
1285FROM	pg_catalog.pg_type fk
1286WHERE	typbasetype != 0 AND
1287	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);
1288 ctid | typbasetype
1289------+-------------
1290(0 rows)
1291
1292SELECT	ctid, typcollation
1293FROM	pg_catalog.pg_type fk
1294WHERE	typcollation != 0 AND
1295	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_collation pk WHERE pk.oid = fk.typcollation);
1296 ctid | typcollation
1297------+--------------
1298(0 rows)
1299
1300SELECT	ctid, conpfeqop
1301FROM	(SELECT ctid, unnest(conpfeqop) AS conpfeqop FROM pg_catalog.pg_constraint) fk
1302WHERE	conpfeqop != 0 AND
1303	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conpfeqop);
1304 ctid | conpfeqop
1305------+-----------
1306(0 rows)
1307
1308SELECT	ctid, conppeqop
1309FROM	(SELECT ctid, unnest(conppeqop) AS conppeqop FROM pg_catalog.pg_constraint) fk
1310WHERE	conppeqop != 0 AND
1311	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conppeqop);
1312 ctid | conppeqop
1313------+-----------
1314(0 rows)
1315
1316SELECT	ctid, conffeqop
1317FROM	(SELECT ctid, unnest(conffeqop) AS conffeqop FROM pg_catalog.pg_constraint) fk
1318WHERE	conffeqop != 0 AND
1319	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conffeqop);
1320 ctid | conffeqop
1321------+-----------
1322(0 rows)
1323
1324SELECT	ctid, conexclop
1325FROM	(SELECT ctid, unnest(conexclop) AS conexclop FROM pg_catalog.pg_constraint) fk
1326WHERE	conexclop != 0 AND
1327	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conexclop);
1328 ctid | conexclop
1329------+-----------
1330(0 rows)
1331
1332SELECT	ctid, proallargtypes
1333FROM	(SELECT ctid, unnest(proallargtypes) AS proallargtypes FROM pg_catalog.pg_proc) fk
1334WHERE	proallargtypes != 0 AND
1335	NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.proallargtypes);
1336 ctid | proallargtypes
1337------+----------------
1338(0 rows)
1339
1340