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