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);
8
SELECT ctid, aggtransfn
9
FROM pg_catalog.pg_aggregate fk
10
WHERE aggtransfn != 0 AND
11
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggtransfn);
12
SELECT ctid, aggfinalfn
13
FROM pg_catalog.pg_aggregate fk
14
WHERE aggfinalfn != 0 AND
15
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aggfinalfn);
16
SELECT ctid, aggsortop
17
FROM pg_catalog.pg_aggregate fk
18
WHERE aggsortop != 0 AND
19
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.aggsortop);
20
SELECT ctid, aggtranstype
21
FROM pg_catalog.pg_aggregate fk
22
WHERE aggtranstype != 0 AND
23
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
24
SELECT ctid, amkeytype
25
FROM pg_catalog.pg_am fk
26
WHERE amkeytype != 0 AND
27
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amkeytype);
29
FROM pg_catalog.pg_am fk
30
WHERE aminsert != 0 AND
31
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aminsert);
32
SELECT ctid, ambeginscan
33
FROM pg_catalog.pg_am fk
34
WHERE ambeginscan != 0 AND
35
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambeginscan);
36
SELECT ctid, amgettuple
37
FROM pg_catalog.pg_am fk
38
WHERE amgettuple != 0 AND
39
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgettuple);
40
SELECT ctid, amgetbitmap
41
FROM pg_catalog.pg_am fk
42
WHERE amgetbitmap != 0 AND
43
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgetbitmap);
45
FROM pg_catalog.pg_am fk
46
WHERE amrescan != 0 AND
47
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrescan);
48
SELECT ctid, amendscan
49
FROM pg_catalog.pg_am fk
50
WHERE amendscan != 0 AND
51
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amendscan);
52
SELECT ctid, ammarkpos
53
FROM pg_catalog.pg_am fk
54
WHERE ammarkpos != 0 AND
55
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ammarkpos);
56
SELECT ctid, amrestrpos
57
FROM pg_catalog.pg_am fk
58
WHERE amrestrpos != 0 AND
59
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrestrpos);
61
FROM pg_catalog.pg_am fk
62
WHERE ambuild != 0 AND
63
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambuild);
64
SELECT ctid, ambuildempty
65
FROM pg_catalog.pg_am fk
66
WHERE ambuildempty != 0 AND
67
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambuildempty);
68
SELECT ctid, ambulkdelete
69
FROM pg_catalog.pg_am fk
70
WHERE ambulkdelete != 0 AND
71
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambulkdelete);
72
SELECT ctid, amvacuumcleanup
73
FROM pg_catalog.pg_am fk
74
WHERE amvacuumcleanup != 0 AND
75
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amvacuumcleanup);
76
SELECT ctid, amcostestimate
77
FROM pg_catalog.pg_am fk
78
WHERE amcostestimate != 0 AND
79
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amcostestimate);
80
SELECT ctid, amoptions
81
FROM pg_catalog.pg_am fk
82
WHERE amoptions != 0 AND
83
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amoptions);
84
SELECT ctid, amopfamily
85
FROM pg_catalog.pg_amop fk
86
WHERE amopfamily != 0 AND
87
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amopfamily);
88
SELECT ctid, amoplefttype
89
FROM pg_catalog.pg_amop fk
90
WHERE amoplefttype != 0 AND
91
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoplefttype);
92
SELECT ctid, amoprighttype
93
FROM pg_catalog.pg_amop fk
94
WHERE amoprighttype != 0 AND
95
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amoprighttype);
97
FROM pg_catalog.pg_amop fk
98
WHERE amopopr != 0 AND
99
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.amopopr);
100
SELECT ctid, amopmethod
101
FROM pg_catalog.pg_amop fk
102
WHERE amopmethod != 0 AND
103
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.amopmethod);
104
SELECT ctid, amopsortfamily
105
FROM pg_catalog.pg_amop fk
106
WHERE amopsortfamily != 0 AND
107
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amopsortfamily);
108
SELECT ctid, amprocfamily
109
FROM pg_catalog.pg_amproc fk
110
WHERE amprocfamily != 0 AND
111
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.amprocfamily);
112
SELECT ctid, amproclefttype
113
FROM pg_catalog.pg_amproc fk
114
WHERE amproclefttype != 0 AND
115
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amproclefttype);
116
SELECT ctid, amprocrighttype
117
FROM pg_catalog.pg_amproc fk
118
WHERE amprocrighttype != 0 AND
119
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocrighttype);
121
FROM pg_catalog.pg_amproc fk
122
WHERE amproc != 0 AND
123
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
125
FROM pg_catalog.pg_attrdef fk
126
WHERE adrelid != 0 AND
127
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.adrelid);
128
SELECT ctid, attrelid
129
FROM pg_catalog.pg_attribute fk
130
WHERE attrelid != 0 AND
131
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.attrelid);
132
SELECT ctid, atttypid
133
FROM pg_catalog.pg_attribute fk
134
WHERE atttypid != 0 AND
135
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.atttypid);
136
SELECT ctid, attcollation
137
FROM pg_catalog.pg_attribute fk
138
WHERE attcollation != 0 AND
139
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_collation pk WHERE pk.oid = fk.attcollation);
140
SELECT ctid, castsource
141
FROM pg_catalog.pg_cast fk
142
WHERE castsource != 0 AND
143
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.castsource);
144
SELECT ctid, casttarget
145
FROM pg_catalog.pg_cast fk
146
WHERE casttarget != 0 AND
147
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.casttarget);
148
SELECT ctid, castfunc
149
FROM pg_catalog.pg_cast fk
150
WHERE castfunc != 0 AND
151
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.castfunc);
152
SELECT ctid, relnamespace
153
FROM pg_catalog.pg_class fk
154
WHERE relnamespace != 0 AND
155
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.relnamespace);
157
FROM pg_catalog.pg_class fk
158
WHERE reltype != 0 AND
159
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reltype);
160
SELECT ctid, reloftype
161
FROM pg_catalog.pg_class fk
162
WHERE reloftype != 0 AND
163
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reloftype);
164
SELECT ctid, relowner
165
FROM pg_catalog.pg_class fk
166
WHERE relowner != 0 AND
167
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.relowner);
169
FROM pg_catalog.pg_class fk
171
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam);
172
SELECT ctid, reltablespace
173
FROM pg_catalog.pg_class fk
174
WHERE reltablespace != 0 AND
175
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace);
176
SELECT ctid, reltoastrelid
177
FROM pg_catalog.pg_class fk
178
WHERE reltoastrelid != 0 AND
179
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
180
SELECT ctid, reltoastidxid
181
FROM pg_catalog.pg_class fk
182
WHERE reltoastidxid != 0 AND
183
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastidxid);
184
SELECT ctid, collnamespace
185
FROM pg_catalog.pg_collation fk
186
WHERE collnamespace != 0 AND
187
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.collnamespace);
188
SELECT ctid, collowner
189
FROM pg_catalog.pg_collation fk
190
WHERE collowner != 0 AND
191
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.collowner);
192
SELECT ctid, connamespace
193
FROM pg_catalog.pg_constraint fk
194
WHERE connamespace != 0 AND
195
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
196
SELECT ctid, conrelid
197
FROM pg_catalog.pg_constraint fk
198
WHERE conrelid != 0 AND
199
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.conrelid);
200
SELECT ctid, contypid
201
FROM pg_catalog.pg_constraint fk
202
WHERE contypid != 0 AND
203
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
204
SELECT ctid, conindid
205
FROM pg_catalog.pg_constraint fk
206
WHERE conindid != 0 AND
207
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.conindid);
208
SELECT ctid, confrelid
209
FROM pg_catalog.pg_constraint fk
210
WHERE confrelid != 0 AND
211
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.confrelid);
212
SELECT ctid, connamespace
213
FROM pg_catalog.pg_conversion fk
214
WHERE connamespace != 0 AND
215
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
216
SELECT ctid, conowner
217
FROM pg_catalog.pg_conversion fk
218
WHERE conowner != 0 AND
219
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.conowner);
221
FROM pg_catalog.pg_conversion fk
222
WHERE conproc != 0 AND
223
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
225
FROM pg_catalog.pg_database fk
226
WHERE datdba != 0 AND
227
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.datdba);
228
SELECT ctid, dattablespace
229
FROM pg_catalog.pg_database fk
230
WHERE dattablespace != 0 AND
231
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace);
232
SELECT ctid, setdatabase
233
FROM pg_catalog.pg_db_role_setting fk
234
WHERE setdatabase != 0 AND
235
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_database pk WHERE pk.oid = fk.setdatabase);
237
FROM pg_catalog.pg_depend fk
238
WHERE classid != 0 AND
239
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
240
SELECT ctid, refclassid
241
FROM pg_catalog.pg_depend fk
242
WHERE refclassid != 0 AND
243
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
244
SELECT ctid, classoid
245
FROM pg_catalog.pg_description fk
246
WHERE classoid != 0 AND
247
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
248
SELECT ctid, enumtypid
249
FROM pg_catalog.pg_enum fk
250
WHERE enumtypid != 0 AND
251
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.enumtypid);
252
SELECT ctid, extowner
253
FROM pg_catalog.pg_extension fk
254
WHERE extowner != 0 AND
255
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.extowner);
256
SELECT ctid, extnamespace
257
FROM pg_catalog.pg_extension fk
258
WHERE extnamespace != 0 AND
259
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.extnamespace);
260
SELECT ctid, indexrelid
261
FROM pg_catalog.pg_index fk
262
WHERE indexrelid != 0 AND
263
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
264
SELECT ctid, indrelid
265
FROM pg_catalog.pg_index fk
266
WHERE indrelid != 0 AND
267
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
268
SELECT ctid, inhrelid
269
FROM pg_catalog.pg_inherits fk
270
WHERE inhrelid != 0 AND
271
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.inhrelid);
272
SELECT ctid, inhparent
273
FROM pg_catalog.pg_inherits fk
274
WHERE inhparent != 0 AND
275
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.inhparent);
276
SELECT ctid, lanowner
277
FROM pg_catalog.pg_language fk
278
WHERE lanowner != 0 AND
279
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.lanowner);
280
SELECT ctid, lanplcallfoid
281
FROM pg_catalog.pg_language fk
282
WHERE lanplcallfoid != 0 AND
283
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanplcallfoid);
284
SELECT ctid, laninline
285
FROM pg_catalog.pg_language fk
286
WHERE laninline != 0 AND
287
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.laninline);
288
SELECT ctid, lanvalidator
289
FROM pg_catalog.pg_language fk
290
WHERE lanvalidator != 0 AND
291
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
292
SELECT ctid, nspowner
293
FROM pg_catalog.pg_namespace fk
294
WHERE nspowner != 0 AND
295
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.nspowner);
296
SELECT ctid, opcmethod
297
FROM pg_catalog.pg_opclass fk
298
WHERE opcmethod != 0 AND
299
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcmethod);
300
SELECT ctid, opcnamespace
301
FROM pg_catalog.pg_opclass fk
302
WHERE opcnamespace != 0 AND
303
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
304
SELECT ctid, opcowner
305
FROM pg_catalog.pg_opclass fk
306
WHERE opcowner != 0 AND
307
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opcowner);
308
SELECT ctid, opcfamily
309
FROM pg_catalog.pg_opclass fk
310
WHERE opcfamily != 0 AND
311
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opfamily pk WHERE pk.oid = fk.opcfamily);
312
SELECT ctid, opcintype
313
FROM pg_catalog.pg_opclass fk
314
WHERE opcintype != 0 AND
315
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
316
SELECT ctid, opckeytype
317
FROM pg_catalog.pg_opclass fk
318
WHERE opckeytype != 0 AND
319
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opckeytype);
320
SELECT ctid, oprnamespace
321
FROM pg_catalog.pg_operator fk
322
WHERE oprnamespace != 0 AND
323
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
324
SELECT ctid, oprowner
325
FROM pg_catalog.pg_operator fk
326
WHERE oprowner != 0 AND
327
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.oprowner);
329
FROM pg_catalog.pg_operator fk
330
WHERE oprleft != 0 AND
331
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
332
SELECT ctid, oprright
333
FROM pg_catalog.pg_operator fk
334
WHERE oprright != 0 AND
335
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
336
SELECT ctid, oprresult
337
FROM pg_catalog.pg_operator fk
338
WHERE oprresult != 0 AND
339
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
341
FROM pg_catalog.pg_operator fk
342
WHERE oprcom != 0 AND
343
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
344
SELECT ctid, oprnegate
345
FROM pg_catalog.pg_operator fk
346
WHERE oprnegate != 0 AND
347
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
349
FROM pg_catalog.pg_operator fk
350
WHERE oprcode != 0 AND
351
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
353
FROM pg_catalog.pg_operator fk
354
WHERE oprrest != 0 AND
355
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
357
FROM pg_catalog.pg_operator fk
358
WHERE oprjoin != 0 AND
359
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
360
SELECT ctid, opfmethod
361
FROM pg_catalog.pg_opfamily fk
362
WHERE opfmethod != 0 AND
363
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opfmethod);
364
SELECT ctid, opfnamespace
365
FROM pg_catalog.pg_opfamily fk
366
WHERE opfnamespace != 0 AND
367
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opfnamespace);
368
SELECT ctid, opfowner
369
FROM pg_catalog.pg_opfamily fk
370
WHERE opfowner != 0 AND
371
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.opfowner);
372
SELECT ctid, pronamespace
373
FROM pg_catalog.pg_proc fk
374
WHERE pronamespace != 0 AND
375
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
376
SELECT ctid, proowner
377
FROM pg_catalog.pg_proc fk
378
WHERE proowner != 0 AND
379
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.proowner);
381
FROM pg_catalog.pg_proc fk
382
WHERE prolang != 0 AND
383
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
384
SELECT ctid, provariadic
385
FROM pg_catalog.pg_proc fk
386
WHERE provariadic != 0 AND
387
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.provariadic);
388
SELECT ctid, prorettype
389
FROM pg_catalog.pg_proc fk
390
WHERE prorettype != 0 AND
391
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
392
SELECT ctid, ev_class
393
FROM pg_catalog.pg_rewrite fk
394
WHERE ev_class != 0 AND
395
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
396
SELECT ctid, refclassid
397
FROM pg_catalog.pg_shdepend fk
398
WHERE refclassid != 0 AND
399
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
400
SELECT ctid, classoid
401
FROM pg_catalog.pg_shdescription fk
402
WHERE classoid != 0 AND
403
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
404
SELECT ctid, starelid
405
FROM pg_catalog.pg_statistic fk
406
WHERE starelid != 0 AND
407
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
409
FROM pg_catalog.pg_statistic fk
410
WHERE staop1 != 0 AND
411
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
413
FROM pg_catalog.pg_statistic fk
414
WHERE staop2 != 0 AND
415
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
417
FROM pg_catalog.pg_statistic fk
418
WHERE staop3 != 0 AND
419
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
420
SELECT ctid, spcowner
421
FROM pg_catalog.pg_tablespace fk
422
WHERE spcowner != 0 AND
423
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.spcowner);
425
FROM pg_catalog.pg_trigger fk
426
WHERE tgrelid != 0 AND
427
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgrelid);
429
FROM pg_catalog.pg_trigger fk
430
WHERE tgfoid != 0 AND
431
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tgfoid);
432
SELECT ctid, tgconstrrelid
433
FROM pg_catalog.pg_trigger fk
434
WHERE tgconstrrelid != 0 AND
435
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgconstrrelid);
436
SELECT ctid, tgconstrindid
437
FROM pg_catalog.pg_trigger fk
438
WHERE tgconstrindid != 0 AND
439
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgconstrindid);
440
SELECT ctid, tgconstraint
441
FROM pg_catalog.pg_trigger fk
442
WHERE tgconstraint != 0 AND
443
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_constraint pk WHERE pk.oid = fk.tgconstraint);
444
SELECT ctid, cfgnamespace
445
FROM pg_catalog.pg_ts_config fk
446
WHERE cfgnamespace != 0 AND
447
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.cfgnamespace);
448
SELECT ctid, cfgowner
449
FROM pg_catalog.pg_ts_config fk
450
WHERE cfgowner != 0 AND
451
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.cfgowner);
452
SELECT ctid, cfgparser
453
FROM pg_catalog.pg_ts_config fk
454
WHERE cfgparser != 0 AND
455
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_parser pk WHERE pk.oid = fk.cfgparser);
457
FROM pg_catalog.pg_ts_config_map fk
458
WHERE mapcfg != 0 AND
459
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_config pk WHERE pk.oid = fk.mapcfg);
461
FROM pg_catalog.pg_ts_config_map fk
462
WHERE mapdict != 0 AND
463
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_dict pk WHERE pk.oid = fk.mapdict);
464
SELECT ctid, dictnamespace
465
FROM pg_catalog.pg_ts_dict fk
466
WHERE dictnamespace != 0 AND
467
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.dictnamespace);
468
SELECT ctid, dictowner
469
FROM pg_catalog.pg_ts_dict fk
470
WHERE dictowner != 0 AND
471
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.dictowner);
472
SELECT ctid, dicttemplate
473
FROM pg_catalog.pg_ts_dict fk
474
WHERE dicttemplate != 0 AND
475
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_ts_template pk WHERE pk.oid = fk.dicttemplate);
476
SELECT ctid, prsnamespace
477
FROM pg_catalog.pg_ts_parser fk
478
WHERE prsnamespace != 0 AND
479
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.prsnamespace);
480
SELECT ctid, prsstart
481
FROM pg_catalog.pg_ts_parser fk
482
WHERE prsstart != 0 AND
483
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsstart);
484
SELECT ctid, prstoken
485
FROM pg_catalog.pg_ts_parser fk
486
WHERE prstoken != 0 AND
487
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prstoken);
489
FROM pg_catalog.pg_ts_parser fk
490
WHERE prsend != 0 AND
491
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsend);
492
SELECT ctid, prsheadline
493
FROM pg_catalog.pg_ts_parser fk
494
WHERE prsheadline != 0 AND
495
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prsheadline);
496
SELECT ctid, prslextype
497
FROM pg_catalog.pg_ts_parser fk
498
WHERE prslextype != 0 AND
499
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.prslextype);
500
SELECT ctid, tmplnamespace
501
FROM pg_catalog.pg_ts_template fk
502
WHERE tmplnamespace != 0 AND
503
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.tmplnamespace);
504
SELECT ctid, tmplinit
505
FROM pg_catalog.pg_ts_template fk
506
WHERE tmplinit != 0 AND
507
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmplinit);
508
SELECT ctid, tmpllexize
509
FROM pg_catalog.pg_ts_template fk
510
WHERE tmpllexize != 0 AND
511
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tmpllexize);
512
SELECT ctid, typnamespace
513
FROM pg_catalog.pg_type fk
514
WHERE typnamespace != 0 AND
515
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
516
SELECT ctid, typowner
517
FROM pg_catalog.pg_type fk
518
WHERE typowner != 0 AND
519
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_authid pk WHERE pk.oid = fk.typowner);
520
SELECT ctid, typrelid
521
FROM pg_catalog.pg_type fk
522
WHERE typrelid != 0 AND
523
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
525
FROM pg_catalog.pg_type fk
526
WHERE typelem != 0 AND
527
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
528
SELECT ctid, typarray
529
FROM pg_catalog.pg_type fk
530
WHERE typarray != 0 AND
531
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typarray);
532
SELECT ctid, typinput
533
FROM pg_catalog.pg_type fk
534
WHERE typinput != 0 AND
535
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
536
SELECT ctid, typoutput
537
FROM pg_catalog.pg_type fk
538
WHERE typoutput != 0 AND
539
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
540
SELECT ctid, typreceive
541
FROM pg_catalog.pg_type fk
542
WHERE typreceive != 0 AND
543
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
545
FROM pg_catalog.pg_type fk
546
WHERE typsend != 0 AND
547
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
548
SELECT ctid, typmodin
549
FROM pg_catalog.pg_type fk
550
WHERE typmodin != 0 AND
551
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodin);
552
SELECT ctid, typmodout
553
FROM pg_catalog.pg_type fk
554
WHERE typmodout != 0 AND
555
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typmodout);
556
SELECT ctid, typanalyze
557
FROM pg_catalog.pg_type fk
558
WHERE typanalyze != 0 AND
559
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typanalyze);
560
SELECT ctid, typbasetype
561
FROM pg_catalog.pg_type fk
562
WHERE typbasetype != 0 AND
563
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);
564
SELECT ctid, typcollation
565
FROM pg_catalog.pg_type fk
566
WHERE typcollation != 0 AND
567
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_collation pk WHERE pk.oid = fk.typcollation);
568
SELECT ctid, conpfeqop
569
FROM (SELECT ctid, unnest(conpfeqop) AS conpfeqop FROM pg_catalog.pg_constraint) fk
570
WHERE conpfeqop != 0 AND
571
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conpfeqop);
572
SELECT ctid, conppeqop
573
FROM (SELECT ctid, unnest(conppeqop) AS conppeqop FROM pg_catalog.pg_constraint) fk
574
WHERE conppeqop != 0 AND
575
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conppeqop);
576
SELECT ctid, conffeqop
577
FROM (SELECT ctid, unnest(conffeqop) AS conffeqop FROM pg_catalog.pg_constraint) fk
578
WHERE conffeqop != 0 AND
579
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.conffeqop);
580
SELECT ctid, proallargtypes
581
FROM (SELECT ctid, unnest(proallargtypes) AS proallargtypes FROM pg_catalog.pg_proc) fk
582
WHERE proallargtypes != 0 AND
583
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.proallargtypes);