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, reltoastrelid
121 FROM pg_catalog.pg_class fk
122 WHERE reltoastrelid != 0 AND
123 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastrelid);
124 SELECT ctid, reltoastidxid
125 FROM pg_catalog.pg_class fk
126 WHERE reltoastidxid != 0 AND
127 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.reltoastidxid);
128 SELECT ctid, connamespace
129 FROM pg_catalog.pg_constraint fk
130 WHERE connamespace != 0 AND
131 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
132 SELECT ctid, contypid
133 FROM pg_catalog.pg_constraint fk
134 WHERE contypid != 0 AND
135 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.contypid);
136 SELECT ctid, connamespace
137 FROM pg_catalog.pg_conversion fk
138 WHERE connamespace != 0 AND
139 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.connamespace);
141 FROM pg_catalog.pg_conversion fk
142 WHERE conproc != 0 AND
143 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.conproc);
145 FROM pg_catalog.pg_depend fk
146 WHERE classid != 0 AND
147 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classid);
148 SELECT ctid, refclassid
149 FROM pg_catalog.pg_depend fk
150 WHERE refclassid != 0 AND
151 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.refclassid);
152 SELECT ctid, classoid
153 FROM pg_catalog.pg_description fk
154 WHERE classoid != 0 AND
155 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.classoid);
156 SELECT ctid, indexrelid
157 FROM pg_catalog.pg_index fk
158 WHERE indexrelid != 0 AND
159 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indexrelid);
160 SELECT ctid, indrelid
161 FROM pg_catalog.pg_index fk
162 WHERE indrelid != 0 AND
163 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.indrelid);
164 SELECT ctid, lanvalidator
165 FROM pg_catalog.pg_language fk
166 WHERE lanvalidator != 0 AND
167 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.lanvalidator);
169 FROM pg_catalog.pg_opclass fk
170 WHERE opcamid != 0 AND
171 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_am pk WHERE pk.oid = fk.opcamid);
172 SELECT ctid, opcnamespace
173 FROM pg_catalog.pg_opclass fk
174 WHERE opcnamespace != 0 AND
175 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.opcnamespace);
176 SELECT ctid, opcintype
177 FROM pg_catalog.pg_opclass fk
178 WHERE opcintype != 0 AND
179 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.opcintype);
180 SELECT ctid, oprnamespace
181 FROM pg_catalog.pg_operator fk
182 WHERE oprnamespace != 0 AND
183 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.oprnamespace);
185 FROM pg_catalog.pg_operator fk
186 WHERE oprleft != 0 AND
187 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprleft);
188 SELECT ctid, oprright
189 FROM pg_catalog.pg_operator fk
190 WHERE oprright != 0 AND
191 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprright);
192 SELECT ctid, oprresult
193 FROM pg_catalog.pg_operator fk
194 WHERE oprresult != 0 AND
195 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.oprresult);
197 FROM pg_catalog.pg_operator fk
198 WHERE oprcom != 0 AND
199 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprcom);
200 SELECT ctid, oprnegate
201 FROM pg_catalog.pg_operator fk
202 WHERE oprnegate != 0 AND
203 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprnegate);
204 SELECT ctid, oprlsortop
205 FROM pg_catalog.pg_operator fk
206 WHERE oprlsortop != 0 AND
207 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprlsortop);
208 SELECT ctid, oprrsortop
209 FROM pg_catalog.pg_operator fk
210 WHERE oprrsortop != 0 AND
211 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprrsortop);
212 SELECT ctid, oprltcmpop
213 FROM pg_catalog.pg_operator fk
214 WHERE oprltcmpop != 0 AND
215 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprltcmpop);
216 SELECT ctid, oprgtcmpop
217 FROM pg_catalog.pg_operator fk
218 WHERE oprgtcmpop != 0 AND
219 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.oprgtcmpop);
221 FROM pg_catalog.pg_operator fk
222 WHERE oprcode != 0 AND
223 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprcode);
225 FROM pg_catalog.pg_operator fk
226 WHERE oprrest != 0 AND
227 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprrest);
229 FROM pg_catalog.pg_operator fk
230 WHERE oprjoin != 0 AND
231 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.oprjoin);
232 SELECT ctid, pronamespace
233 FROM pg_catalog.pg_proc fk
234 WHERE pronamespace != 0 AND
235 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.pronamespace);
237 FROM pg_catalog.pg_proc fk
238 WHERE prolang != 0 AND
239 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_language pk WHERE pk.oid = fk.prolang);
240 SELECT ctid, prorettype
241 FROM pg_catalog.pg_proc fk
242 WHERE prorettype != 0 AND
243 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.prorettype);
244 SELECT ctid, ev_class
245 FROM pg_catalog.pg_rewrite fk
246 WHERE ev_class != 0 AND
247 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.ev_class);
248 SELECT ctid, starelid
249 FROM pg_catalog.pg_statistic fk
250 WHERE starelid != 0 AND
251 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.starelid);
253 FROM pg_catalog.pg_statistic fk
254 WHERE staop1 != 0 AND
255 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop1);
257 FROM pg_catalog.pg_statistic fk
258 WHERE staop2 != 0 AND
259 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop2);
261 FROM pg_catalog.pg_statistic fk
262 WHERE staop3 != 0 AND
263 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_operator pk WHERE pk.oid = fk.staop3);
265 FROM pg_catalog.pg_trigger fk
266 WHERE tgrelid != 0 AND
267 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.tgrelid);
269 FROM pg_catalog.pg_trigger fk
270 WHERE tgfoid != 0 AND
271 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.tgfoid);
272 SELECT ctid, typnamespace
273 FROM pg_catalog.pg_type fk
274 WHERE typnamespace != 0 AND
275 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_namespace pk WHERE pk.oid = fk.typnamespace);
276 SELECT ctid, typrelid
277 FROM pg_catalog.pg_type fk
278 WHERE typrelid != 0 AND
279 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_class pk WHERE pk.oid = fk.typrelid);
281 FROM pg_catalog.pg_type fk
282 WHERE typelem != 0 AND
283 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typelem);
284 SELECT ctid, typinput
285 FROM pg_catalog.pg_type fk
286 WHERE typinput != 0 AND
287 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typinput);
288 SELECT ctid, typoutput
289 FROM pg_catalog.pg_type fk
290 WHERE typoutput != 0 AND
291 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typoutput);
292 SELECT ctid, typreceive
293 FROM pg_catalog.pg_type fk
294 WHERE typreceive != 0 AND
295 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typreceive);
297 FROM pg_catalog.pg_type fk
298 WHERE typsend != 0 AND
299 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_proc pk WHERE pk.oid = fk.typsend);
300 SELECT ctid, typbasetype
301 FROM pg_catalog.pg_type fk
302 WHERE typbasetype != 0 AND
303 NOT EXISTS(SELECT 1 FROM pg_catalog.pg_type pk WHERE pk.oid = fk.typbasetype);