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