2
-- This is created by pgsql/contrib/findoidjoins/make_oidjoin_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, aggtranstype
17
FROM pg_catalog.pg_aggregate fk
18
WHERE aggtranstype != 0 AND
19
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.aggtranstype);
20
SELECT ctid, amgettuple
21
FROM pg_catalog.pg_am fk
22
WHERE amgettuple != 0 AND
23
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amgettuple);
25
FROM pg_catalog.pg_am fk
26
WHERE aminsert != 0 AND
27
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.aminsert);
28
SELECT ctid, ambeginscan
29
FROM pg_catalog.pg_am fk
30
WHERE ambeginscan != 0 AND
31
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambeginscan);
33
FROM pg_catalog.pg_am fk
34
WHERE amrescan != 0 AND
35
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrescan);
36
SELECT ctid, amendscan
37
FROM pg_catalog.pg_am fk
38
WHERE amendscan != 0 AND
39
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amendscan);
40
SELECT ctid, ammarkpos
41
FROM pg_catalog.pg_am fk
42
WHERE ammarkpos != 0 AND
43
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ammarkpos);
44
SELECT ctid, amrestrpos
45
FROM pg_catalog.pg_am fk
46
WHERE amrestrpos != 0 AND
47
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amrestrpos);
49
FROM pg_catalog.pg_am fk
50
WHERE ambuild != 0 AND
51
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambuild);
52
SELECT ctid, ambulkdelete
53
FROM pg_catalog.pg_am fk
54
WHERE ambulkdelete != 0 AND
55
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.ambulkdelete);
56
SELECT ctid, amvacuumcleanup
57
FROM pg_catalog.pg_am fk
58
WHERE amvacuumcleanup != 0 AND
59
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amvacuumcleanup);
60
SELECT ctid, amcostestimate
61
FROM pg_catalog.pg_am fk
62
WHERE amcostestimate != 0 AND
63
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amcostestimate);
64
SELECT ctid, amopclaid
65
FROM pg_catalog.pg_amop fk
66
WHERE amopclaid != 0 AND
67
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid);
68
SELECT ctid, amopsubtype
69
FROM pg_catalog.pg_amop fk
70
WHERE amopsubtype != 0 AND
71
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amopsubtype);
73
FROM pg_catalog.pg_amop fk
74
WHERE amopopr != 0 AND
75
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.amopopr);
76
SELECT ctid, amopclaid
77
FROM pg_catalog.pg_amproc fk
78
WHERE amopclaid != 0 AND
79
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_opclass pk WHERE pk.oid = fk.amopclaid);
80
SELECT ctid, amprocsubtype
81
FROM pg_catalog.pg_amproc fk
82
WHERE amprocsubtype != 0 AND
83
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.amprocsubtype);
85
FROM pg_catalog.pg_amproc fk
87
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.amproc);
89
FROM pg_catalog.pg_attribute fk
90
WHERE attrelid != 0 AND
91
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.attrelid);
93
FROM pg_catalog.pg_attribute fk
94
WHERE atttypid != 0 AND
95
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.atttypid);
96
SELECT ctid, castsource
97
FROM pg_catalog.pg_cast fk
98
WHERE castsource != 0 AND
99
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.castsource);
100
SELECT ctid, casttarget
101
FROM pg_catalog.pg_cast fk
102
WHERE casttarget != 0 AND
103
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.casttarget);
104
SELECT ctid, castfunc
105
FROM pg_catalog.pg_cast fk
106
WHERE castfunc != 0 AND
107
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.castfunc);
108
SELECT ctid, relnamespace
109
FROM pg_catalog.pg_class fk
110
WHERE relnamespace != 0 AND
111
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.relnamespace);
113
FROM pg_catalog.pg_class fk
114
WHERE reltype != 0 AND
115
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.reltype);
117
FROM pg_catalog.pg_class fk
119
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.relam);
120
SELECT ctid, reltablespace
121
FROM pg_catalog.pg_class fk
122
WHERE reltablespace != 0 AND
123
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.reltablespace);
124
SELECT ctid, reltoastrelid
125
FROM pg_catalog.pg_class fk
126
WHERE reltoastrelid != 0 AND
127
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
128
SELECT ctid, reltoastidxid
129
FROM pg_catalog.pg_class fk
130
WHERE reltoastidxid != 0 AND
131
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastidxid);
132
SELECT ctid, connamespace
133
FROM pg_catalog.pg_constraint fk
134
WHERE connamespace != 0 AND
135
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
136
SELECT ctid, contypid
137
FROM pg_catalog.pg_constraint fk
138
WHERE contypid != 0 AND
139
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
140
SELECT ctid, connamespace
141
FROM pg_catalog.pg_conversion fk
142
WHERE connamespace != 0 AND
143
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
145
FROM pg_catalog.pg_conversion fk
146
WHERE conproc != 0 AND
147
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
148
SELECT ctid, dattablespace
149
FROM pg_catalog.pg_database fk
150
WHERE dattablespace != 0 AND
151
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_tablespace pk WHERE pk.oid = fk.dattablespace);
153
FROM pg_catalog.pg_depend fk
154
WHERE classid != 0 AND
155
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
156
SELECT ctid, refclassid
157
FROM pg_catalog.pg_depend fk
158
WHERE refclassid != 0 AND
159
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
160
SELECT ctid, classoid
161
FROM pg_catalog.pg_description fk
162
WHERE classoid != 0 AND
163
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
164
SELECT ctid, indexrelid
165
FROM pg_catalog.pg_index fk
166
WHERE indexrelid != 0 AND
167
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
168
SELECT ctid, indrelid
169
FROM pg_catalog.pg_index fk
170
WHERE indrelid != 0 AND
171
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
172
SELECT ctid, lanvalidator
173
FROM pg_catalog.pg_language fk
174
WHERE lanvalidator != 0 AND
175
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
177
FROM pg_catalog.pg_opclass fk
178
WHERE opcamid != 0 AND
179
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcamid);
180
SELECT ctid, opcnamespace
181
FROM pg_catalog.pg_opclass fk
182
WHERE opcnamespace != 0 AND
183
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
184
SELECT ctid, opcintype
185
FROM pg_catalog.pg_opclass fk
186
WHERE opcintype != 0 AND
187
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
188
SELECT ctid, oprnamespace
189
FROM pg_catalog.pg_operator fk
190
WHERE oprnamespace != 0 AND
191
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
193
FROM pg_catalog.pg_operator fk
194
WHERE oprleft != 0 AND
195
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
196
SELECT ctid, oprright
197
FROM pg_catalog.pg_operator fk
198
WHERE oprright != 0 AND
199
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
200
SELECT ctid, oprresult
201
FROM pg_catalog.pg_operator fk
202
WHERE oprresult != 0 AND
203
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
205
FROM pg_catalog.pg_operator fk
206
WHERE oprcom != 0 AND
207
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
208
SELECT ctid, oprnegate
209
FROM pg_catalog.pg_operator fk
210
WHERE oprnegate != 0 AND
211
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
212
SELECT ctid, oprlsortop
213
FROM pg_catalog.pg_operator fk
214
WHERE oprlsortop != 0 AND
215
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprlsortop);
216
SELECT ctid, oprrsortop
217
FROM pg_catalog.pg_operator fk
218
WHERE oprrsortop != 0 AND
219
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprrsortop);
220
SELECT ctid, oprltcmpop
221
FROM pg_catalog.pg_operator fk
222
WHERE oprltcmpop != 0 AND
223
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprltcmpop);
224
SELECT ctid, oprgtcmpop
225
FROM pg_catalog.pg_operator fk
226
WHERE oprgtcmpop != 0 AND
227
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprgtcmpop);
229
FROM pg_catalog.pg_operator fk
230
WHERE oprcode != 0 AND
231
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
233
FROM pg_catalog.pg_operator fk
234
WHERE oprrest != 0 AND
235
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
237
FROM pg_catalog.pg_operator fk
238
WHERE oprjoin != 0 AND
239
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
240
SELECT ctid, pronamespace
241
FROM pg_catalog.pg_proc fk
242
WHERE pronamespace != 0 AND
243
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
245
FROM pg_catalog.pg_proc fk
246
WHERE prolang != 0 AND
247
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
248
SELECT ctid, prorettype
249
FROM pg_catalog.pg_proc fk
250
WHERE prorettype != 0 AND
251
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
252
SELECT ctid, ev_class
253
FROM pg_catalog.pg_rewrite fk
254
WHERE ev_class != 0 AND
255
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
256
SELECT ctid, starelid
257
FROM pg_catalog.pg_statistic fk
258
WHERE starelid != 0 AND
259
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
261
FROM pg_catalog.pg_statistic fk
262
WHERE staop1 != 0 AND
263
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
265
FROM pg_catalog.pg_statistic fk
266
WHERE staop2 != 0 AND
267
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
269
FROM pg_catalog.pg_statistic fk
270
WHERE staop3 != 0 AND
271
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
273
FROM pg_catalog.pg_trigger fk
274
WHERE tgrelid != 0 AND
275
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgrelid);
277
FROM pg_catalog.pg_trigger fk
278
WHERE tgfoid != 0 AND
279
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tgfoid);
280
SELECT ctid, typnamespace
281
FROM pg_catalog.pg_type fk
282
WHERE typnamespace != 0 AND
283
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
284
SELECT ctid, typrelid
285
FROM pg_catalog.pg_type fk
286
WHERE typrelid != 0 AND
287
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
289
FROM pg_catalog.pg_type fk
290
WHERE typelem != 0 AND
291
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
292
SELECT ctid, typinput
293
FROM pg_catalog.pg_type fk
294
WHERE typinput != 0 AND
295
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
296
SELECT ctid, typoutput
297
FROM pg_catalog.pg_type fk
298
WHERE typoutput != 0 AND
299
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
300
SELECT ctid, typreceive
301
FROM pg_catalog.pg_type fk
302
WHERE typreceive != 0 AND
303
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
305
FROM pg_catalog.pg_type fk
306
WHERE typsend != 0 AND
307
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
308
SELECT ctid, typbasetype
309
FROM pg_catalog.pg_type fk
310
WHERE typbasetype != 0 AND
311
NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);