github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join1.ref.golden (about) 1 // Code generated by TestPretty. DO NOT EDIT. 2 // GENERATED FILE DO NOT EDIT 3 1: 4 - 5 SELECT 6 NULL::STRING 7 AS pktable_cat, 8 pkn.nspname 9 AS pktable_schem, 10 pkc.relname 11 AS pktable_name, 12 pka.attname 13 AS pkcolumn_name, 14 NULL::STRING 15 AS fktable_cat, 16 fkn.nspname 17 AS fktable_schem, 18 fkc.relname 19 AS fktable_name, 20 fka.attname 21 AS fkcolumn_name, 22 pos.n 23 AS key_seq, 24 CASE con.confupdtype 25 WHEN 'c' 26 THEN 0 27 WHEN 'n' 28 THEN 2 29 WHEN 'd' 30 THEN 4 31 WHEN 'r' 32 THEN 1 33 WHEN 'a' 34 THEN 3 35 ELSE NULL 36 END 37 AS update_rule, 38 CASE con.confdeltype 39 WHEN 'c' 40 THEN 0 41 WHEN 'n' 42 THEN 2 43 WHEN 'd' 44 THEN 4 45 WHEN 'r' 46 THEN 1 47 WHEN 'a' 48 THEN 3 49 ELSE NULL 50 END 51 AS delete_rule, 52 con.conname 53 AS fk_name, 54 pkic.relname 55 AS pk_name, 56 CASE 57 WHEN con.condeferrable 58 AND con.condeferred 59 THEN 5 60 WHEN con.condeferrable 61 THEN 6 62 ELSE 7 63 END 64 AS deferrability 65 FROM 66 pg_catalog.pg_namespace 67 AS pkn, 68 pg_catalog.pg_class 69 AS pkc, 70 pg_catalog.pg_attribute 71 AS pka, 72 pg_catalog.pg_namespace 73 AS fkn, 74 pg_catalog.pg_class 75 AS fkc, 76 pg_catalog.pg_attribute 77 AS fka, 78 pg_catalog.pg_constraint 79 AS con, 80 pg_catalog.generate_series( 81 1, 82 32 83 ) 84 AS pos 85 ( 86 n 87 ), 88 pg_catalog.pg_depend 89 AS dep, 90 pg_catalog.pg_class 91 AS pkic 92 WHERE 93 pkn.oid 94 = pkc.relnamespace 95 AND pkc.oid 96 = pka.attrelid 97 AND pka.attnum 98 = con.confkey[pos.n] 99 AND con.confrelid 100 = pkc.oid 101 AND fkn.oid 102 = fkc.relnamespace 103 AND fkc.oid 104 = fka.attrelid 105 AND fka.attnum 106 = con.conkey[pos.n] 107 AND con.conrelid 108 = fkc.oid 109 AND con.contype 110 = 'f' 111 AND con.oid 112 = dep.objid 113 AND pkic.oid 114 = dep.refobjid 115 AND pkic.relkind 116 = 'i' 117 AND dep.classid 118 = 'pg_constraint'::REGCLASS::OID 119 AND dep.refclassid 120 = 'pg_class'::REGCLASS::OID 121 AND fkn.nspname 122 = 'public' 123 AND fkc.relname 124 = 'orders' 125 ORDER BY 126 pkn.nspname, 127 pkc.relname, 128 con.conname, 129 pos.n 130 131 16: 132 ---------------- 133 SELECT 134 NULL::STRING 135 AS pktable_cat, 136 pkn.nspname 137 AS pktable_schem, 138 pkc.relname 139 AS pktable_name, 140 pka.attname 141 AS pkcolumn_name, 142 NULL::STRING 143 AS fktable_cat, 144 fkn.nspname 145 AS fktable_schem, 146 fkc.relname 147 AS fktable_name, 148 fka.attname 149 AS fkcolumn_name, 150 pos.n 151 AS key_seq, 152 CASE con.confupdtype 153 WHEN 'c' 154 THEN 0 155 WHEN 'n' 156 THEN 2 157 WHEN 'd' 158 THEN 4 159 WHEN 'r' 160 THEN 1 161 WHEN 'a' 162 THEN 3 163 ELSE NULL 164 END 165 AS update_rule, 166 CASE con.confdeltype 167 WHEN 'c' 168 THEN 0 169 WHEN 'n' 170 THEN 2 171 WHEN 'd' 172 THEN 4 173 WHEN 'r' 174 THEN 1 175 WHEN 'a' 176 THEN 3 177 ELSE NULL 178 END 179 AS delete_rule, 180 con.conname 181 AS fk_name, 182 pkic.relname 183 AS pk_name, 184 CASE 185 WHEN con.condeferrable 186 AND con.condeferred 187 THEN 5 188 WHEN con.condeferrable 189 THEN 6 190 ELSE 7 191 END 192 AS deferrability 193 FROM 194 pg_catalog.pg_namespace 195 AS pkn, 196 pg_catalog.pg_class 197 AS pkc, 198 pg_catalog.pg_attribute 199 AS pka, 200 pg_catalog.pg_namespace 201 AS fkn, 202 pg_catalog.pg_class 203 AS fkc, 204 pg_catalog.pg_attribute 205 AS fka, 206 pg_catalog.pg_constraint 207 AS con, 208 pg_catalog.generate_series( 209 1, 210 32 211 ) 212 AS pos 213 (n), 214 pg_catalog.pg_depend 215 AS dep, 216 pg_catalog.pg_class 217 AS pkic 218 WHERE 219 pkn.oid 220 = pkc.relnamespace 221 AND pkc.oid 222 = pka.attrelid 223 AND pka.attnum 224 = con.confkey[pos.n] 225 AND con.confrelid 226 = pkc.oid 227 AND fkn.oid 228 = fkc.relnamespace 229 AND fkc.oid 230 = fka.attrelid 231 AND fka.attnum 232 = con.conkey[pos.n] 233 AND con.conrelid 234 = fkc.oid 235 AND con.contype 236 = 'f' 237 AND con.oid 238 = dep.objid 239 AND pkic.oid 240 = dep.refobjid 241 AND pkic.relkind 242 = 'i' 243 AND dep.classid 244 = 'pg_constraint'::REGCLASS::OID 245 AND dep.refclassid 246 = 'pg_class'::REGCLASS::OID 247 AND fkn.nspname 248 = 'public' 249 AND fkc.relname 250 = 'orders' 251 ORDER BY 252 pkn.nspname, 253 pkc.relname, 254 con.conname, 255 pos.n 256 257 19: 258 ------------------- 259 SELECT 260 NULL::STRING 261 AS pktable_cat, 262 pkn.nspname 263 AS pktable_schem, 264 pkc.relname 265 AS pktable_name, 266 pka.attname 267 AS pkcolumn_name, 268 NULL::STRING 269 AS fktable_cat, 270 fkn.nspname 271 AS fktable_schem, 272 fkc.relname 273 AS fktable_name, 274 fka.attname 275 AS fkcolumn_name, 276 pos.n 277 AS key_seq, 278 CASE con.confupdtype 279 WHEN 'c' THEN 0 280 WHEN 'n' THEN 2 281 WHEN 'd' THEN 4 282 WHEN 'r' THEN 1 283 WHEN 'a' THEN 3 284 ELSE NULL 285 END 286 AS update_rule, 287 CASE con.confdeltype 288 WHEN 'c' THEN 0 289 WHEN 'n' THEN 2 290 WHEN 'd' THEN 4 291 WHEN 'r' THEN 1 292 WHEN 'a' THEN 3 293 ELSE NULL 294 END 295 AS delete_rule, 296 con.conname 297 AS fk_name, 298 pkic.relname 299 AS pk_name, 300 CASE 301 WHEN con.condeferrable 302 AND con.condeferred 303 THEN 5 304 WHEN con.condeferrable 305 THEN 6 306 ELSE 7 307 END 308 AS deferrability 309 FROM 310 pg_catalog.pg_namespace 311 AS pkn, 312 pg_catalog.pg_class 313 AS pkc, 314 pg_catalog.pg_attribute 315 AS pka, 316 pg_catalog.pg_namespace 317 AS fkn, 318 pg_catalog.pg_class 319 AS fkc, 320 pg_catalog.pg_attribute 321 AS fka, 322 pg_catalog.pg_constraint 323 AS con, 324 pg_catalog.generate_series( 325 1, 326 32 327 ) 328 AS pos (n), 329 pg_catalog.pg_depend 330 AS dep, 331 pg_catalog.pg_class 332 AS pkic 333 WHERE 334 pkn.oid 335 = pkc.relnamespace 336 AND pkc.oid 337 = pka.attrelid 338 AND pka.attnum 339 = con.confkey[pos.n] 340 AND con.confrelid 341 = pkc.oid 342 AND fkn.oid 343 = fkc.relnamespace 344 AND fkc.oid 345 = fka.attrelid 346 AND fka.attnum 347 = con.conkey[pos.n] 348 AND con.conrelid 349 = fkc.oid 350 AND con.contype 351 = 'f' 352 AND con.oid 353 = dep.objid 354 AND pkic.oid 355 = dep.refobjid 356 AND pkic.relkind 357 = 'i' 358 AND dep.classid 359 = 'pg_constraint'::REGCLASS::OID 360 AND dep.refclassid 361 = 'pg_class'::REGCLASS::OID 362 AND fkn.nspname 363 = 'public' 364 AND fkc.relname 365 = 'orders' 366 ORDER BY 367 pkn.nspname, 368 pkc.relname, 369 con.conname, 370 pos.n 371 372 21: 373 --------------------- 374 SELECT 375 NULL::STRING 376 AS pktable_cat, 377 pkn.nspname 378 AS pktable_schem, 379 pkc.relname 380 AS pktable_name, 381 pka.attname 382 AS pkcolumn_name, 383 NULL::STRING 384 AS fktable_cat, 385 fkn.nspname 386 AS fktable_schem, 387 fkc.relname 388 AS fktable_name, 389 fka.attname 390 AS fkcolumn_name, 391 pos.n AS key_seq, 392 CASE con.confupdtype 393 WHEN 'c' THEN 0 394 WHEN 'n' THEN 2 395 WHEN 'd' THEN 4 396 WHEN 'r' THEN 1 397 WHEN 'a' THEN 3 398 ELSE NULL 399 END 400 AS update_rule, 401 CASE con.confdeltype 402 WHEN 'c' THEN 0 403 WHEN 'n' THEN 2 404 WHEN 'd' THEN 4 405 WHEN 'r' THEN 1 406 WHEN 'a' THEN 3 407 ELSE NULL 408 END 409 AS delete_rule, 410 con.conname 411 AS fk_name, 412 pkic.relname 413 AS pk_name, 414 CASE 415 WHEN con.condeferrable 416 AND con.condeferred 417 THEN 5 418 WHEN con.condeferrable 419 THEN 6 420 ELSE 7 421 END 422 AS deferrability 423 FROM 424 pg_catalog.pg_namespace 425 AS pkn, 426 pg_catalog.pg_class 427 AS pkc, 428 pg_catalog.pg_attribute 429 AS pka, 430 pg_catalog.pg_namespace 431 AS fkn, 432 pg_catalog.pg_class 433 AS fkc, 434 pg_catalog.pg_attribute 435 AS fka, 436 pg_catalog.pg_constraint 437 AS con, 438 pg_catalog.generate_series( 439 1, 440 32 441 ) 442 AS pos (n), 443 pg_catalog.pg_depend 444 AS dep, 445 pg_catalog.pg_class 446 AS pkic 447 WHERE 448 pkn.oid 449 = pkc.relnamespace 450 AND pkc.oid 451 = pka.attrelid 452 AND pka.attnum 453 = con.confkey[pos.n] 454 AND con.confrelid 455 = pkc.oid 456 AND fkn.oid 457 = fkc.relnamespace 458 AND fkc.oid 459 = fka.attrelid 460 AND fka.attnum 461 = con.conkey[pos.n] 462 AND con.conrelid 463 = fkc.oid 464 AND con.contype 465 = 'f' 466 AND con.oid 467 = dep.objid 468 AND pkic.oid 469 = dep.refobjid 470 AND pkic.relkind 471 = 'i' 472 AND dep.classid 473 = 'pg_constraint'::REGCLASS::OID 474 AND dep.refclassid 475 = 'pg_class'::REGCLASS::OID 476 AND fkn.nspname 477 = 'public' 478 AND fkc.relname 479 = 'orders' 480 ORDER BY 481 pkn.nspname, 482 pkc.relname, 483 con.conname, 484 pos.n 485 486 25: 487 ------------------------- 488 SELECT 489 NULL::STRING 490 AS pktable_cat, 491 pkn.nspname 492 AS pktable_schem, 493 pkc.relname 494 AS pktable_name, 495 pka.attname 496 AS pkcolumn_name, 497 NULL::STRING 498 AS fktable_cat, 499 fkn.nspname 500 AS fktable_schem, 501 fkc.relname 502 AS fktable_name, 503 fka.attname 504 AS fkcolumn_name, 505 pos.n AS key_seq, 506 CASE con.confupdtype 507 WHEN 'c' THEN 0 508 WHEN 'n' THEN 2 509 WHEN 'd' THEN 4 510 WHEN 'r' THEN 1 511 WHEN 'a' THEN 3 512 ELSE NULL 513 END 514 AS update_rule, 515 CASE con.confdeltype 516 WHEN 'c' THEN 0 517 WHEN 'n' THEN 2 518 WHEN 'd' THEN 4 519 WHEN 'r' THEN 1 520 WHEN 'a' THEN 3 521 ELSE NULL 522 END 523 AS delete_rule, 524 con.conname 525 AS fk_name, 526 pkic.relname 527 AS pk_name, 528 CASE 529 WHEN con.condeferrable 530 AND con.condeferred 531 THEN 5 532 WHEN con.condeferrable 533 THEN 6 534 ELSE 7 535 END 536 AS deferrability 537 FROM 538 pg_catalog.pg_namespace 539 AS pkn, 540 pg_catalog.pg_class 541 AS pkc, 542 pg_catalog.pg_attribute 543 AS pka, 544 pg_catalog.pg_namespace 545 AS fkn, 546 pg_catalog.pg_class 547 AS fkc, 548 pg_catalog.pg_attribute 549 AS fka, 550 pg_catalog.pg_constraint 551 AS con, 552 pg_catalog.generate_series( 553 1, 554 32 555 ) 556 AS pos (n), 557 pg_catalog.pg_depend 558 AS dep, 559 pg_catalog.pg_class 560 AS pkic 561 WHERE 562 pkn.oid 563 = pkc.relnamespace 564 AND pkc.oid 565 = pka.attrelid 566 AND pka.attnum 567 = con.confkey[pos.n] 568 AND con.confrelid 569 = pkc.oid 570 AND fkn.oid 571 = fkc.relnamespace 572 AND fkc.oid 573 = fka.attrelid 574 AND fka.attnum 575 = con.conkey[pos.n] 576 AND con.conrelid 577 = fkc.oid 578 AND con.contype = 'f' 579 AND con.oid 580 = dep.objid 581 AND pkic.oid 582 = dep.refobjid 583 AND pkic.relkind 584 = 'i' 585 AND dep.classid 586 = 'pg_constraint'::REGCLASS::OID 587 AND dep.refclassid 588 = 'pg_class'::REGCLASS::OID 589 AND fkn.nspname 590 = 'public' 591 AND fkc.relname 592 = 'orders' 593 ORDER BY 594 pkn.nspname, 595 pkc.relname, 596 con.conname, 597 pos.n 598 599 26: 600 -------------------------- 601 SELECT 602 NULL::STRING 603 AS pktable_cat, 604 pkn.nspname 605 AS pktable_schem, 606 pkc.relname 607 AS pktable_name, 608 pka.attname 609 AS pkcolumn_name, 610 NULL::STRING 611 AS fktable_cat, 612 fkn.nspname 613 AS fktable_schem, 614 fkc.relname 615 AS fktable_name, 616 fka.attname 617 AS fkcolumn_name, 618 pos.n AS key_seq, 619 CASE con.confupdtype 620 WHEN 'c' THEN 0 621 WHEN 'n' THEN 2 622 WHEN 'd' THEN 4 623 WHEN 'r' THEN 1 624 WHEN 'a' THEN 3 625 ELSE NULL 626 END 627 AS update_rule, 628 CASE con.confdeltype 629 WHEN 'c' THEN 0 630 WHEN 'n' THEN 2 631 WHEN 'd' THEN 4 632 WHEN 'r' THEN 1 633 WHEN 'a' THEN 3 634 ELSE NULL 635 END 636 AS delete_rule, 637 con.conname 638 AS fk_name, 639 pkic.relname 640 AS pk_name, 641 CASE 642 WHEN con.condeferrable 643 AND con.condeferred 644 THEN 5 645 WHEN con.condeferrable 646 THEN 6 647 ELSE 7 648 END 649 AS deferrability 650 FROM 651 pg_catalog.pg_namespace 652 AS pkn, 653 pg_catalog.pg_class 654 AS pkc, 655 pg_catalog.pg_attribute 656 AS pka, 657 pg_catalog.pg_namespace 658 AS fkn, 659 pg_catalog.pg_class 660 AS fkc, 661 pg_catalog.pg_attribute 662 AS fka, 663 pg_catalog.pg_constraint 664 AS con, 665 pg_catalog.generate_series( 666 1, 667 32 668 ) 669 AS pos (n), 670 pg_catalog.pg_depend 671 AS dep, 672 pg_catalog.pg_class 673 AS pkic 674 WHERE 675 pkn.oid 676 = pkc.relnamespace 677 AND pkc.oid 678 = pka.attrelid 679 AND pka.attnum 680 = con.confkey[pos.n] 681 AND con.confrelid 682 = pkc.oid 683 AND fkn.oid 684 = fkc.relnamespace 685 AND fkc.oid 686 = fka.attrelid 687 AND fka.attnum 688 = con.conkey[pos.n] 689 AND con.conrelid 690 = fkc.oid 691 AND con.contype = 'f' 692 AND con.oid 693 = dep.objid 694 AND pkic.oid 695 = dep.refobjid 696 AND pkic.relkind = 'i' 697 AND dep.classid 698 = 'pg_constraint'::REGCLASS::OID 699 AND dep.refclassid 700 = 'pg_class'::REGCLASS::OID 701 AND fkn.nspname 702 = 'public' 703 AND fkc.relname 704 = 'orders' 705 ORDER BY 706 pkn.nspname, 707 pkc.relname, 708 con.conname, 709 pos.n 710 711 27: 712 --------------------------- 713 SELECT 714 NULL::STRING 715 AS pktable_cat, 716 pkn.nspname 717 AS pktable_schem, 718 pkc.relname 719 AS pktable_name, 720 pka.attname 721 AS pkcolumn_name, 722 NULL::STRING 723 AS fktable_cat, 724 fkn.nspname 725 AS fktable_schem, 726 fkc.relname 727 AS fktable_name, 728 fka.attname 729 AS fkcolumn_name, 730 pos.n AS key_seq, 731 CASE con.confupdtype 732 WHEN 'c' THEN 0 733 WHEN 'n' THEN 2 734 WHEN 'd' THEN 4 735 WHEN 'r' THEN 1 736 WHEN 'a' THEN 3 737 ELSE NULL 738 END 739 AS update_rule, 740 CASE con.confdeltype 741 WHEN 'c' THEN 0 742 WHEN 'n' THEN 2 743 WHEN 'd' THEN 4 744 WHEN 'r' THEN 1 745 WHEN 'a' THEN 3 746 ELSE NULL 747 END 748 AS delete_rule, 749 con.conname AS fk_name, 750 pkic.relname 751 AS pk_name, 752 CASE 753 WHEN con.condeferrable 754 AND con.condeferred 755 THEN 5 756 WHEN con.condeferrable 757 THEN 6 758 ELSE 7 759 END 760 AS deferrability 761 FROM 762 pg_catalog.pg_namespace 763 AS pkn, 764 pg_catalog.pg_class 765 AS pkc, 766 pg_catalog.pg_attribute 767 AS pka, 768 pg_catalog.pg_namespace 769 AS fkn, 770 pg_catalog.pg_class 771 AS fkc, 772 pg_catalog.pg_attribute 773 AS fka, 774 pg_catalog.pg_constraint 775 AS con, 776 pg_catalog.generate_series( 777 1, 778 32 779 ) 780 AS pos (n), 781 pg_catalog.pg_depend 782 AS dep, 783 pg_catalog.pg_class 784 AS pkic 785 WHERE 786 pkn.oid 787 = pkc.relnamespace 788 AND pkc.oid 789 = pka.attrelid 790 AND pka.attnum 791 = con.confkey[pos.n] 792 AND con.confrelid 793 = pkc.oid 794 AND fkn.oid 795 = fkc.relnamespace 796 AND fkc.oid 797 = fka.attrelid 798 AND fka.attnum 799 = con.conkey[pos.n] 800 AND con.conrelid 801 = fkc.oid 802 AND con.contype = 'f' 803 AND con.oid = dep.objid 804 AND pkic.oid 805 = dep.refobjid 806 AND pkic.relkind = 'i' 807 AND dep.classid 808 = 'pg_constraint'::REGCLASS::OID 809 AND dep.refclassid 810 = 'pg_class'::REGCLASS::OID 811 AND fkn.nspname 812 = 'public' 813 AND fkc.relname 814 = 'orders' 815 ORDER BY 816 pkn.nspname, 817 pkc.relname, 818 con.conname, 819 pos.n 820 821 28: 822 ---------------------------- 823 SELECT 824 NULL::STRING 825 AS pktable_cat, 826 pkn.nspname 827 AS pktable_schem, 828 pkc.relname 829 AS pktable_name, 830 pka.attname 831 AS pkcolumn_name, 832 NULL::STRING 833 AS fktable_cat, 834 fkn.nspname 835 AS fktable_schem, 836 fkc.relname 837 AS fktable_name, 838 fka.attname 839 AS fkcolumn_name, 840 pos.n AS key_seq, 841 CASE con.confupdtype 842 WHEN 'c' THEN 0 843 WHEN 'n' THEN 2 844 WHEN 'd' THEN 4 845 WHEN 'r' THEN 1 846 WHEN 'a' THEN 3 847 ELSE NULL 848 END 849 AS update_rule, 850 CASE con.confdeltype 851 WHEN 'c' THEN 0 852 WHEN 'n' THEN 2 853 WHEN 'd' THEN 4 854 WHEN 'r' THEN 1 855 WHEN 'a' THEN 3 856 ELSE NULL 857 END 858 AS delete_rule, 859 con.conname AS fk_name, 860 pkic.relname AS pk_name, 861 CASE 862 WHEN con.condeferrable 863 AND con.condeferred 864 THEN 5 865 WHEN con.condeferrable 866 THEN 6 867 ELSE 7 868 END 869 AS deferrability 870 FROM 871 pg_catalog.pg_namespace 872 AS pkn, 873 pg_catalog.pg_class 874 AS pkc, 875 pg_catalog.pg_attribute 876 AS pka, 877 pg_catalog.pg_namespace 878 AS fkn, 879 pg_catalog.pg_class 880 AS fkc, 881 pg_catalog.pg_attribute 882 AS fka, 883 pg_catalog.pg_constraint 884 AS con, 885 pg_catalog.generate_series( 886 1, 887 32 888 ) 889 AS pos (n), 890 pg_catalog.pg_depend 891 AS dep, 892 pg_catalog.pg_class 893 AS pkic 894 WHERE 895 pkn.oid 896 = pkc.relnamespace 897 AND pkc.oid 898 = pka.attrelid 899 AND pka.attnum 900 = con.confkey[pos.n] 901 AND con.confrelid 902 = pkc.oid 903 AND fkn.oid 904 = fkc.relnamespace 905 AND fkc.oid 906 = fka.attrelid 907 AND fka.attnum 908 = con.conkey[pos.n] 909 AND con.conrelid 910 = fkc.oid 911 AND con.contype = 'f' 912 AND con.oid = dep.objid 913 AND pkic.oid 914 = dep.refobjid 915 AND pkic.relkind = 'i' 916 AND dep.classid 917 = 'pg_constraint'::REGCLASS::OID 918 AND dep.refclassid 919 = 'pg_class'::REGCLASS::OID 920 AND fkn.nspname 921 = 'public' 922 AND fkc.relname 923 = 'orders' 924 ORDER BY 925 pkn.nspname, 926 pkc.relname, 927 con.conname, 928 pos.n 929 930 30: 931 ------------------------------ 932 SELECT 933 NULL::STRING 934 AS pktable_cat, 935 pkn.nspname 936 AS pktable_schem, 937 pkc.relname 938 AS pktable_name, 939 pka.attname 940 AS pkcolumn_name, 941 NULL::STRING 942 AS fktable_cat, 943 fkn.nspname 944 AS fktable_schem, 945 fkc.relname 946 AS fktable_name, 947 fka.attname 948 AS fkcolumn_name, 949 pos.n AS key_seq, 950 CASE con.confupdtype 951 WHEN 'c' THEN 0 952 WHEN 'n' THEN 2 953 WHEN 'd' THEN 4 954 WHEN 'r' THEN 1 955 WHEN 'a' THEN 3 956 ELSE NULL 957 END 958 AS update_rule, 959 CASE con.confdeltype 960 WHEN 'c' THEN 0 961 WHEN 'n' THEN 2 962 WHEN 'd' THEN 4 963 WHEN 'r' THEN 1 964 WHEN 'a' THEN 3 965 ELSE NULL 966 END 967 AS delete_rule, 968 con.conname AS fk_name, 969 pkic.relname AS pk_name, 970 CASE 971 WHEN con.condeferrable 972 AND con.condeferred 973 THEN 5 974 WHEN con.condeferrable 975 THEN 6 976 ELSE 7 977 END 978 AS deferrability 979 FROM 980 pg_catalog.pg_namespace 981 AS pkn, 982 pg_catalog.pg_class 983 AS pkc, 984 pg_catalog.pg_attribute 985 AS pka, 986 pg_catalog.pg_namespace 987 AS fkn, 988 pg_catalog.pg_class 989 AS fkc, 990 pg_catalog.pg_attribute 991 AS fka, 992 pg_catalog.pg_constraint 993 AS con, 994 pg_catalog.generate_series( 995 1, 996 32 997 ) 998 AS pos (n), 999 pg_catalog.pg_depend 1000 AS dep, 1001 pg_catalog.pg_class 1002 AS pkic 1003 WHERE 1004 pkn.oid = pkc.relnamespace 1005 AND pkc.oid = pka.attrelid 1006 AND pka.attnum 1007 = con.confkey[pos.n] 1008 AND con.confrelid 1009 = pkc.oid 1010 AND fkn.oid 1011 = fkc.relnamespace 1012 AND fkc.oid = fka.attrelid 1013 AND fka.attnum 1014 = con.conkey[pos.n] 1015 AND con.conrelid = fkc.oid 1016 AND con.contype = 'f' 1017 AND con.oid = dep.objid 1018 AND pkic.oid 1019 = dep.refobjid 1020 AND pkic.relkind = 'i' 1021 AND dep.classid 1022 = 'pg_constraint'::REGCLASS::OID 1023 AND dep.refclassid 1024 = 'pg_class'::REGCLASS::OID 1025 AND fkn.nspname = 'public' 1026 AND fkc.relname = 'orders' 1027 ORDER BY 1028 pkn.nspname, 1029 pkc.relname, 1030 con.conname, 1031 pos.n 1032 1033 31: 1034 ------------------------------- 1035 SELECT 1036 NULL::STRING 1037 AS pktable_cat, 1038 pkn.nspname 1039 AS pktable_schem, 1040 pkc.relname 1041 AS pktable_name, 1042 pka.attname 1043 AS pkcolumn_name, 1044 NULL::STRING 1045 AS fktable_cat, 1046 fkn.nspname 1047 AS fktable_schem, 1048 fkc.relname 1049 AS fktable_name, 1050 fka.attname 1051 AS fkcolumn_name, 1052 pos.n AS key_seq, 1053 CASE con.confupdtype 1054 WHEN 'c' THEN 0 1055 WHEN 'n' THEN 2 1056 WHEN 'd' THEN 4 1057 WHEN 'r' THEN 1 1058 WHEN 'a' THEN 3 1059 ELSE NULL 1060 END 1061 AS update_rule, 1062 CASE con.confdeltype 1063 WHEN 'c' THEN 0 1064 WHEN 'n' THEN 2 1065 WHEN 'd' THEN 4 1066 WHEN 'r' THEN 1 1067 WHEN 'a' THEN 3 1068 ELSE NULL 1069 END 1070 AS delete_rule, 1071 con.conname AS fk_name, 1072 pkic.relname AS pk_name, 1073 CASE 1074 WHEN con.condeferrable 1075 AND con.condeferred 1076 THEN 5 1077 WHEN con.condeferrable 1078 THEN 6 1079 ELSE 7 1080 END 1081 AS deferrability 1082 FROM 1083 pg_catalog.pg_namespace 1084 AS pkn, 1085 pg_catalog.pg_class AS pkc, 1086 pg_catalog.pg_attribute 1087 AS pka, 1088 pg_catalog.pg_namespace 1089 AS fkn, 1090 pg_catalog.pg_class AS fkc, 1091 pg_catalog.pg_attribute 1092 AS fka, 1093 pg_catalog.pg_constraint 1094 AS con, 1095 pg_catalog.generate_series( 1096 1, 1097 32 1098 ) 1099 AS pos (n), 1100 pg_catalog.pg_depend 1101 AS dep, 1102 pg_catalog.pg_class AS pkic 1103 WHERE 1104 pkn.oid = pkc.relnamespace 1105 AND pkc.oid = pka.attrelid 1106 AND pka.attnum 1107 = con.confkey[pos.n] 1108 AND con.confrelid = pkc.oid 1109 AND fkn.oid 1110 = fkc.relnamespace 1111 AND fkc.oid = fka.attrelid 1112 AND fka.attnum 1113 = con.conkey[pos.n] 1114 AND con.conrelid = fkc.oid 1115 AND con.contype = 'f' 1116 AND con.oid = dep.objid 1117 AND pkic.oid = dep.refobjid 1118 AND pkic.relkind = 'i' 1119 AND dep.classid 1120 = 'pg_constraint'::REGCLASS::OID 1121 AND dep.refclassid 1122 = 'pg_class'::REGCLASS::OID 1123 AND fkn.nspname = 'public' 1124 AND fkc.relname = 'orders' 1125 ORDER BY 1126 pkn.nspname, 1127 pkc.relname, 1128 con.conname, 1129 pos.n 1130 1131 32: 1132 -------------------------------- 1133 SELECT 1134 NULL::STRING AS pktable_cat, 1135 pkn.nspname 1136 AS pktable_schem, 1137 pkc.relname AS pktable_name, 1138 pka.attname 1139 AS pkcolumn_name, 1140 NULL::STRING AS fktable_cat, 1141 fkn.nspname 1142 AS fktable_schem, 1143 fkc.relname AS fktable_name, 1144 fka.attname 1145 AS fkcolumn_name, 1146 pos.n AS key_seq, 1147 CASE con.confupdtype 1148 WHEN 'c' THEN 0 1149 WHEN 'n' THEN 2 1150 WHEN 'd' THEN 4 1151 WHEN 'r' THEN 1 1152 WHEN 'a' THEN 3 1153 ELSE NULL 1154 END 1155 AS update_rule, 1156 CASE con.confdeltype 1157 WHEN 'c' THEN 0 1158 WHEN 'n' THEN 2 1159 WHEN 'd' THEN 4 1160 WHEN 'r' THEN 1 1161 WHEN 'a' THEN 3 1162 ELSE NULL 1163 END 1164 AS delete_rule, 1165 con.conname AS fk_name, 1166 pkic.relname AS pk_name, 1167 CASE 1168 WHEN con.condeferrable 1169 AND con.condeferred 1170 THEN 5 1171 WHEN con.condeferrable 1172 THEN 6 1173 ELSE 7 1174 END 1175 AS deferrability 1176 FROM 1177 pg_catalog.pg_namespace 1178 AS pkn, 1179 pg_catalog.pg_class AS pkc, 1180 pg_catalog.pg_attribute 1181 AS pka, 1182 pg_catalog.pg_namespace 1183 AS fkn, 1184 pg_catalog.pg_class AS fkc, 1185 pg_catalog.pg_attribute 1186 AS fka, 1187 pg_catalog.pg_constraint 1188 AS con, 1189 pg_catalog.generate_series( 1190 1, 1191 32 1192 ) 1193 AS pos (n), 1194 pg_catalog.pg_depend AS dep, 1195 pg_catalog.pg_class AS pkic 1196 WHERE 1197 pkn.oid = pkc.relnamespace 1198 AND pkc.oid = pka.attrelid 1199 AND pka.attnum 1200 = con.confkey[pos.n] 1201 AND con.confrelid = pkc.oid 1202 AND fkn.oid 1203 = fkc.relnamespace 1204 AND fkc.oid = fka.attrelid 1205 AND fka.attnum 1206 = con.conkey[pos.n] 1207 AND con.conrelid = fkc.oid 1208 AND con.contype = 'f' 1209 AND con.oid = dep.objid 1210 AND pkic.oid = dep.refobjid 1211 AND pkic.relkind = 'i' 1212 AND dep.classid 1213 = 'pg_constraint'::REGCLASS::OID 1214 AND dep.refclassid 1215 = 'pg_class'::REGCLASS::OID 1216 AND fkn.nspname = 'public' 1217 AND fkc.relname = 'orders' 1218 ORDER BY 1219 pkn.nspname, 1220 pkc.relname, 1221 con.conname, 1222 pos.n 1223 1224 33: 1225 --------------------------------- 1226 SELECT 1227 NULL::STRING AS pktable_cat, 1228 pkn.nspname AS pktable_schem, 1229 pkc.relname AS pktable_name, 1230 pka.attname AS pkcolumn_name, 1231 NULL::STRING AS fktable_cat, 1232 fkn.nspname AS fktable_schem, 1233 fkc.relname AS fktable_name, 1234 fka.attname AS fkcolumn_name, 1235 pos.n AS key_seq, 1236 CASE con.confupdtype 1237 WHEN 'c' THEN 0 1238 WHEN 'n' THEN 2 1239 WHEN 'd' THEN 4 1240 WHEN 'r' THEN 1 1241 WHEN 'a' THEN 3 1242 ELSE NULL 1243 END 1244 AS update_rule, 1245 CASE con.confdeltype 1246 WHEN 'c' THEN 0 1247 WHEN 'n' THEN 2 1248 WHEN 'd' THEN 4 1249 WHEN 'r' THEN 1 1250 WHEN 'a' THEN 3 1251 ELSE NULL 1252 END 1253 AS delete_rule, 1254 con.conname AS fk_name, 1255 pkic.relname AS pk_name, 1256 CASE 1257 WHEN con.condeferrable 1258 AND con.condeferred 1259 THEN 5 1260 WHEN con.condeferrable THEN 6 1261 ELSE 7 1262 END 1263 AS deferrability 1264 FROM 1265 pg_catalog.pg_namespace 1266 AS pkn, 1267 pg_catalog.pg_class AS pkc, 1268 pg_catalog.pg_attribute 1269 AS pka, 1270 pg_catalog.pg_namespace 1271 AS fkn, 1272 pg_catalog.pg_class AS fkc, 1273 pg_catalog.pg_attribute 1274 AS fka, 1275 pg_catalog.pg_constraint 1276 AS con, 1277 pg_catalog.generate_series( 1278 1, 1279 32 1280 ) 1281 AS pos (n), 1282 pg_catalog.pg_depend AS dep, 1283 pg_catalog.pg_class AS pkic 1284 WHERE 1285 pkn.oid = pkc.relnamespace 1286 AND pkc.oid = pka.attrelid 1287 AND pka.attnum 1288 = con.confkey[pos.n] 1289 AND con.confrelid = pkc.oid 1290 AND fkn.oid 1291 = fkc.relnamespace 1292 AND fkc.oid = fka.attrelid 1293 AND fka.attnum 1294 = con.conkey[pos.n] 1295 AND con.conrelid = fkc.oid 1296 AND con.contype = 'f' 1297 AND con.oid = dep.objid 1298 AND pkic.oid = dep.refobjid 1299 AND pkic.relkind = 'i' 1300 AND dep.classid 1301 = 'pg_constraint'::REGCLASS::OID 1302 AND dep.refclassid 1303 = 'pg_class'::REGCLASS::OID 1304 AND fkn.nspname = 'public' 1305 AND fkc.relname = 'orders' 1306 ORDER BY 1307 pkn.nspname, 1308 pkc.relname, 1309 con.conname, 1310 pos.n 1311 1312 34: 1313 ---------------------------------- 1314 SELECT 1315 NULL::STRING AS pktable_cat, 1316 pkn.nspname AS pktable_schem, 1317 pkc.relname AS pktable_name, 1318 pka.attname AS pkcolumn_name, 1319 NULL::STRING AS fktable_cat, 1320 fkn.nspname AS fktable_schem, 1321 fkc.relname AS fktable_name, 1322 fka.attname AS fkcolumn_name, 1323 pos.n AS key_seq, 1324 CASE con.confupdtype 1325 WHEN 'c' THEN 0 1326 WHEN 'n' THEN 2 1327 WHEN 'd' THEN 4 1328 WHEN 'r' THEN 1 1329 WHEN 'a' THEN 3 1330 ELSE NULL 1331 END 1332 AS update_rule, 1333 CASE con.confdeltype 1334 WHEN 'c' THEN 0 1335 WHEN 'n' THEN 2 1336 WHEN 'd' THEN 4 1337 WHEN 'r' THEN 1 1338 WHEN 'a' THEN 3 1339 ELSE NULL 1340 END 1341 AS delete_rule, 1342 con.conname AS fk_name, 1343 pkic.relname AS pk_name, 1344 CASE 1345 WHEN con.condeferrable 1346 AND con.condeferred 1347 THEN 5 1348 WHEN con.condeferrable THEN 6 1349 ELSE 7 1350 END 1351 AS deferrability 1352 FROM 1353 pg_catalog.pg_namespace 1354 AS pkn, 1355 pg_catalog.pg_class AS pkc, 1356 pg_catalog.pg_attribute 1357 AS pka, 1358 pg_catalog.pg_namespace 1359 AS fkn, 1360 pg_catalog.pg_class AS fkc, 1361 pg_catalog.pg_attribute 1362 AS fka, 1363 pg_catalog.pg_constraint 1364 AS con, 1365 pg_catalog.generate_series( 1366 1, 1367 32 1368 ) 1369 AS pos (n), 1370 pg_catalog.pg_depend AS dep, 1371 pg_catalog.pg_class AS pkic 1372 WHERE 1373 pkn.oid = pkc.relnamespace 1374 AND pkc.oid = pka.attrelid 1375 AND pka.attnum 1376 = con.confkey[pos.n] 1377 AND con.confrelid = pkc.oid 1378 AND fkn.oid = fkc.relnamespace 1379 AND fkc.oid = fka.attrelid 1380 AND fka.attnum 1381 = con.conkey[pos.n] 1382 AND con.conrelid = fkc.oid 1383 AND con.contype = 'f' 1384 AND con.oid = dep.objid 1385 AND pkic.oid = dep.refobjid 1386 AND pkic.relkind = 'i' 1387 AND dep.classid 1388 = 'pg_constraint'::REGCLASS::OID 1389 AND dep.refclassid 1390 = 'pg_class'::REGCLASS::OID 1391 AND fkn.nspname = 'public' 1392 AND fkc.relname = 'orders' 1393 ORDER BY 1394 pkn.nspname, 1395 pkc.relname, 1396 con.conname, 1397 pos.n 1398 1399 35: 1400 ----------------------------------- 1401 SELECT 1402 NULL::STRING AS pktable_cat, 1403 pkn.nspname AS pktable_schem, 1404 pkc.relname AS pktable_name, 1405 pka.attname AS pkcolumn_name, 1406 NULL::STRING AS fktable_cat, 1407 fkn.nspname AS fktable_schem, 1408 fkc.relname AS fktable_name, 1409 fka.attname AS fkcolumn_name, 1410 pos.n AS key_seq, 1411 CASE con.confupdtype 1412 WHEN 'c' THEN 0 1413 WHEN 'n' THEN 2 1414 WHEN 'd' THEN 4 1415 WHEN 'r' THEN 1 1416 WHEN 'a' THEN 3 1417 ELSE NULL 1418 END 1419 AS update_rule, 1420 CASE con.confdeltype 1421 WHEN 'c' THEN 0 1422 WHEN 'n' THEN 2 1423 WHEN 'd' THEN 4 1424 WHEN 'r' THEN 1 1425 WHEN 'a' THEN 3 1426 ELSE NULL 1427 END 1428 AS delete_rule, 1429 con.conname AS fk_name, 1430 pkic.relname AS pk_name, 1431 CASE 1432 WHEN con.condeferrable 1433 AND con.condeferred 1434 THEN 5 1435 WHEN con.condeferrable THEN 6 1436 ELSE 7 1437 END 1438 AS deferrability 1439 FROM 1440 pg_catalog.pg_namespace AS pkn, 1441 pg_catalog.pg_class AS pkc, 1442 pg_catalog.pg_attribute AS pka, 1443 pg_catalog.pg_namespace AS fkn, 1444 pg_catalog.pg_class AS fkc, 1445 pg_catalog.pg_attribute AS fka, 1446 pg_catalog.pg_constraint 1447 AS con, 1448 pg_catalog.generate_series( 1449 1, 1450 32 1451 ) 1452 AS pos (n), 1453 pg_catalog.pg_depend AS dep, 1454 pg_catalog.pg_class AS pkic 1455 WHERE 1456 pkn.oid = pkc.relnamespace 1457 AND pkc.oid = pka.attrelid 1458 AND pka.attnum 1459 = con.confkey[pos.n] 1460 AND con.confrelid = pkc.oid 1461 AND fkn.oid = fkc.relnamespace 1462 AND fkc.oid = fka.attrelid 1463 AND fka.attnum 1464 = con.conkey[pos.n] 1465 AND con.conrelid = fkc.oid 1466 AND con.contype = 'f' 1467 AND con.oid = dep.objid 1468 AND pkic.oid = dep.refobjid 1469 AND pkic.relkind = 'i' 1470 AND dep.classid 1471 = 'pg_constraint'::REGCLASS::OID 1472 AND dep.refclassid 1473 = 'pg_class'::REGCLASS::OID 1474 AND fkn.nspname = 'public' 1475 AND fkc.relname = 'orders' 1476 ORDER BY 1477 pkn.nspname, 1478 pkc.relname, 1479 con.conname, 1480 pos.n 1481 1482 36: 1483 ------------------------------------ 1484 SELECT 1485 NULL::STRING AS pktable_cat, 1486 pkn.nspname AS pktable_schem, 1487 pkc.relname AS pktable_name, 1488 pka.attname AS pkcolumn_name, 1489 NULL::STRING AS fktable_cat, 1490 fkn.nspname AS fktable_schem, 1491 fkc.relname AS fktable_name, 1492 fka.attname AS fkcolumn_name, 1493 pos.n AS key_seq, 1494 CASE con.confupdtype 1495 WHEN 'c' THEN 0 1496 WHEN 'n' THEN 2 1497 WHEN 'd' THEN 4 1498 WHEN 'r' THEN 1 1499 WHEN 'a' THEN 3 1500 ELSE NULL 1501 END 1502 AS update_rule, 1503 CASE con.confdeltype 1504 WHEN 'c' THEN 0 1505 WHEN 'n' THEN 2 1506 WHEN 'd' THEN 4 1507 WHEN 'r' THEN 1 1508 WHEN 'a' THEN 3 1509 ELSE NULL 1510 END 1511 AS delete_rule, 1512 con.conname AS fk_name, 1513 pkic.relname AS pk_name, 1514 CASE 1515 WHEN con.condeferrable 1516 AND con.condeferred 1517 THEN 5 1518 WHEN con.condeferrable THEN 6 1519 ELSE 7 1520 END 1521 AS deferrability 1522 FROM 1523 pg_catalog.pg_namespace AS pkn, 1524 pg_catalog.pg_class AS pkc, 1525 pg_catalog.pg_attribute AS pka, 1526 pg_catalog.pg_namespace AS fkn, 1527 pg_catalog.pg_class AS fkc, 1528 pg_catalog.pg_attribute AS fka, 1529 pg_catalog.pg_constraint AS con, 1530 pg_catalog.generate_series( 1531 1, 1532 32 1533 ) 1534 AS pos (n), 1535 pg_catalog.pg_depend AS dep, 1536 pg_catalog.pg_class AS pkic 1537 WHERE 1538 pkn.oid = pkc.relnamespace 1539 AND pkc.oid = pka.attrelid 1540 AND pka.attnum 1541 = con.confkey[pos.n] 1542 AND con.confrelid = pkc.oid 1543 AND fkn.oid = fkc.relnamespace 1544 AND fkc.oid = fka.attrelid 1545 AND fka.attnum 1546 = con.conkey[pos.n] 1547 AND con.conrelid = fkc.oid 1548 AND con.contype = 'f' 1549 AND con.oid = dep.objid 1550 AND pkic.oid = dep.refobjid 1551 AND pkic.relkind = 'i' 1552 AND dep.classid 1553 = 'pg_constraint'::REGCLASS::OID 1554 AND dep.refclassid 1555 = 'pg_class'::REGCLASS::OID 1556 AND fkn.nspname = 'public' 1557 AND fkc.relname = 'orders' 1558 ORDER BY 1559 pkn.nspname, 1560 pkc.relname, 1561 con.conname, 1562 pos.n 1563 1564 37: 1565 ------------------------------------- 1566 SELECT 1567 NULL::STRING AS pktable_cat, 1568 pkn.nspname AS pktable_schem, 1569 pkc.relname AS pktable_name, 1570 pka.attname AS pkcolumn_name, 1571 NULL::STRING AS fktable_cat, 1572 fkn.nspname AS fktable_schem, 1573 fkc.relname AS fktable_name, 1574 fka.attname AS fkcolumn_name, 1575 pos.n AS key_seq, 1576 CASE con.confupdtype 1577 WHEN 'c' THEN 0 1578 WHEN 'n' THEN 2 1579 WHEN 'd' THEN 4 1580 WHEN 'r' THEN 1 1581 WHEN 'a' THEN 3 1582 ELSE NULL 1583 END 1584 AS update_rule, 1585 CASE con.confdeltype 1586 WHEN 'c' THEN 0 1587 WHEN 'n' THEN 2 1588 WHEN 'd' THEN 4 1589 WHEN 'r' THEN 1 1590 WHEN 'a' THEN 3 1591 ELSE NULL 1592 END 1593 AS delete_rule, 1594 con.conname AS fk_name, 1595 pkic.relname AS pk_name, 1596 CASE 1597 WHEN con.condeferrable 1598 AND con.condeferred 1599 THEN 5 1600 WHEN con.condeferrable THEN 6 1601 ELSE 7 1602 END 1603 AS deferrability 1604 FROM 1605 pg_catalog.pg_namespace AS pkn, 1606 pg_catalog.pg_class AS pkc, 1607 pg_catalog.pg_attribute AS pka, 1608 pg_catalog.pg_namespace AS fkn, 1609 pg_catalog.pg_class AS fkc, 1610 pg_catalog.pg_attribute AS fka, 1611 pg_catalog.pg_constraint AS con, 1612 pg_catalog.generate_series(1, 32) 1613 AS pos (n), 1614 pg_catalog.pg_depend AS dep, 1615 pg_catalog.pg_class AS pkic 1616 WHERE 1617 pkn.oid = pkc.relnamespace 1618 AND pkc.oid = pka.attrelid 1619 AND pka.attnum 1620 = con.confkey[pos.n] 1621 AND con.confrelid = pkc.oid 1622 AND fkn.oid = fkc.relnamespace 1623 AND fkc.oid = fka.attrelid 1624 AND fka.attnum 1625 = con.conkey[pos.n] 1626 AND con.conrelid = fkc.oid 1627 AND con.contype = 'f' 1628 AND con.oid = dep.objid 1629 AND pkic.oid = dep.refobjid 1630 AND pkic.relkind = 'i' 1631 AND dep.classid 1632 = 'pg_constraint'::REGCLASS::OID 1633 AND dep.refclassid 1634 = 'pg_class'::REGCLASS::OID 1635 AND fkn.nspname = 'public' 1636 AND fkc.relname = 'orders' 1637 ORDER BY 1638 pkn.nspname, 1639 pkc.relname, 1640 con.conname, 1641 pos.n 1642 1643 38: 1644 -------------------------------------- 1645 SELECT 1646 NULL::STRING AS pktable_cat, 1647 pkn.nspname AS pktable_schem, 1648 pkc.relname AS pktable_name, 1649 pka.attname AS pkcolumn_name, 1650 NULL::STRING AS fktable_cat, 1651 fkn.nspname AS fktable_schem, 1652 fkc.relname AS fktable_name, 1653 fka.attname AS fkcolumn_name, 1654 pos.n AS key_seq, 1655 CASE con.confupdtype 1656 WHEN 'c' THEN 0 1657 WHEN 'n' THEN 2 1658 WHEN 'd' THEN 4 1659 WHEN 'r' THEN 1 1660 WHEN 'a' THEN 3 1661 ELSE NULL 1662 END 1663 AS update_rule, 1664 CASE con.confdeltype 1665 WHEN 'c' THEN 0 1666 WHEN 'n' THEN 2 1667 WHEN 'd' THEN 4 1668 WHEN 'r' THEN 1 1669 WHEN 'a' THEN 3 1670 ELSE NULL 1671 END 1672 AS delete_rule, 1673 con.conname AS fk_name, 1674 pkic.relname AS pk_name, 1675 CASE 1676 WHEN con.condeferrable 1677 AND con.condeferred 1678 THEN 5 1679 WHEN con.condeferrable THEN 6 1680 ELSE 7 1681 END 1682 AS deferrability 1683 FROM 1684 pg_catalog.pg_namespace AS pkn, 1685 pg_catalog.pg_class AS pkc, 1686 pg_catalog.pg_attribute AS pka, 1687 pg_catalog.pg_namespace AS fkn, 1688 pg_catalog.pg_class AS fkc, 1689 pg_catalog.pg_attribute AS fka, 1690 pg_catalog.pg_constraint AS con, 1691 pg_catalog.generate_series(1, 32) 1692 AS pos (n), 1693 pg_catalog.pg_depend AS dep, 1694 pg_catalog.pg_class AS pkic 1695 WHERE 1696 pkn.oid = pkc.relnamespace 1697 AND pkc.oid = pka.attrelid 1698 AND pka.attnum 1699 = con.confkey[pos.n] 1700 AND con.confrelid = pkc.oid 1701 AND fkn.oid = fkc.relnamespace 1702 AND fkc.oid = fka.attrelid 1703 AND fka.attnum = con.conkey[pos.n] 1704 AND con.conrelid = fkc.oid 1705 AND con.contype = 'f' 1706 AND con.oid = dep.objid 1707 AND pkic.oid = dep.refobjid 1708 AND pkic.relkind = 'i' 1709 AND dep.classid 1710 = 'pg_constraint'::REGCLASS::OID 1711 AND dep.refclassid 1712 = 'pg_class'::REGCLASS::OID 1713 AND fkn.nspname = 'public' 1714 AND fkc.relname = 'orders' 1715 ORDER BY 1716 pkn.nspname, 1717 pkc.relname, 1718 con.conname, 1719 pos.n 1720 1721 39: 1722 --------------------------------------- 1723 SELECT 1724 NULL::STRING AS pktable_cat, 1725 pkn.nspname AS pktable_schem, 1726 pkc.relname AS pktable_name, 1727 pka.attname AS pkcolumn_name, 1728 NULL::STRING AS fktable_cat, 1729 fkn.nspname AS fktable_schem, 1730 fkc.relname AS fktable_name, 1731 fka.attname AS fkcolumn_name, 1732 pos.n AS key_seq, 1733 CASE con.confupdtype 1734 WHEN 'c' THEN 0 1735 WHEN 'n' THEN 2 1736 WHEN 'd' THEN 4 1737 WHEN 'r' THEN 1 1738 WHEN 'a' THEN 3 1739 ELSE NULL 1740 END 1741 AS update_rule, 1742 CASE con.confdeltype 1743 WHEN 'c' THEN 0 1744 WHEN 'n' THEN 2 1745 WHEN 'd' THEN 4 1746 WHEN 'r' THEN 1 1747 WHEN 'a' THEN 3 1748 ELSE NULL 1749 END 1750 AS delete_rule, 1751 con.conname AS fk_name, 1752 pkic.relname AS pk_name, 1753 CASE 1754 WHEN con.condeferrable 1755 AND con.condeferred 1756 THEN 5 1757 WHEN con.condeferrable THEN 6 1758 ELSE 7 1759 END 1760 AS deferrability 1761 FROM 1762 pg_catalog.pg_namespace AS pkn, 1763 pg_catalog.pg_class AS pkc, 1764 pg_catalog.pg_attribute AS pka, 1765 pg_catalog.pg_namespace AS fkn, 1766 pg_catalog.pg_class AS fkc, 1767 pg_catalog.pg_attribute AS fka, 1768 pg_catalog.pg_constraint AS con, 1769 pg_catalog.generate_series(1, 32) 1770 AS pos (n), 1771 pg_catalog.pg_depend AS dep, 1772 pg_catalog.pg_class AS pkic 1773 WHERE 1774 pkn.oid = pkc.relnamespace 1775 AND pkc.oid = pka.attrelid 1776 AND pka.attnum = con.confkey[pos.n] 1777 AND con.confrelid = pkc.oid 1778 AND fkn.oid = fkc.relnamespace 1779 AND fkc.oid = fka.attrelid 1780 AND fka.attnum = con.conkey[pos.n] 1781 AND con.conrelid = fkc.oid 1782 AND con.contype = 'f' 1783 AND con.oid = dep.objid 1784 AND pkic.oid = dep.refobjid 1785 AND pkic.relkind = 'i' 1786 AND dep.classid 1787 = 'pg_constraint'::REGCLASS::OID 1788 AND dep.refclassid 1789 = 'pg_class'::REGCLASS::OID 1790 AND fkn.nspname = 'public' 1791 AND fkc.relname = 'orders' 1792 ORDER BY 1793 pkn.nspname, 1794 pkc.relname, 1795 con.conname, 1796 pos.n 1797 1798 46: 1799 ---------------------------------------------- 1800 SELECT 1801 NULL::STRING AS pktable_cat, 1802 pkn.nspname AS pktable_schem, 1803 pkc.relname AS pktable_name, 1804 pka.attname AS pkcolumn_name, 1805 NULL::STRING AS fktable_cat, 1806 fkn.nspname AS fktable_schem, 1807 fkc.relname AS fktable_name, 1808 fka.attname AS fkcolumn_name, 1809 pos.n AS key_seq, 1810 CASE con.confupdtype 1811 WHEN 'c' THEN 0 1812 WHEN 'n' THEN 2 1813 WHEN 'd' THEN 4 1814 WHEN 'r' THEN 1 1815 WHEN 'a' THEN 3 1816 ELSE NULL 1817 END 1818 AS update_rule, 1819 CASE con.confdeltype 1820 WHEN 'c' THEN 0 1821 WHEN 'n' THEN 2 1822 WHEN 'd' THEN 4 1823 WHEN 'r' THEN 1 1824 WHEN 'a' THEN 3 1825 ELSE NULL 1826 END 1827 AS delete_rule, 1828 con.conname AS fk_name, 1829 pkic.relname AS pk_name, 1830 CASE 1831 WHEN con.condeferrable AND con.condeferred 1832 THEN 5 1833 WHEN con.condeferrable THEN 6 1834 ELSE 7 1835 END 1836 AS deferrability 1837 FROM 1838 pg_catalog.pg_namespace AS pkn, 1839 pg_catalog.pg_class AS pkc, 1840 pg_catalog.pg_attribute AS pka, 1841 pg_catalog.pg_namespace AS fkn, 1842 pg_catalog.pg_class AS fkc, 1843 pg_catalog.pg_attribute AS fka, 1844 pg_catalog.pg_constraint AS con, 1845 pg_catalog.generate_series(1, 32) 1846 AS pos (n), 1847 pg_catalog.pg_depend AS dep, 1848 pg_catalog.pg_class AS pkic 1849 WHERE 1850 pkn.oid = pkc.relnamespace 1851 AND pkc.oid = pka.attrelid 1852 AND pka.attnum = con.confkey[pos.n] 1853 AND con.confrelid = pkc.oid 1854 AND fkn.oid = fkc.relnamespace 1855 AND fkc.oid = fka.attrelid 1856 AND fka.attnum = con.conkey[pos.n] 1857 AND con.conrelid = fkc.oid 1858 AND con.contype = 'f' 1859 AND con.oid = dep.objid 1860 AND pkic.oid = dep.refobjid 1861 AND pkic.relkind = 'i' 1862 AND dep.classid 1863 = 'pg_constraint'::REGCLASS::OID 1864 AND dep.refclassid 1865 = 'pg_class'::REGCLASS::OID 1866 AND fkn.nspname = 'public' 1867 AND fkc.relname = 'orders' 1868 ORDER BY 1869 pkn.nspname, 1870 pkc.relname, 1871 con.conname, 1872 pos.n 1873 1874 48: 1875 ------------------------------------------------ 1876 SELECT 1877 NULL::STRING AS pktable_cat, 1878 pkn.nspname AS pktable_schem, 1879 pkc.relname AS pktable_name, 1880 pka.attname AS pkcolumn_name, 1881 NULL::STRING AS fktable_cat, 1882 fkn.nspname AS fktable_schem, 1883 fkc.relname AS fktable_name, 1884 fka.attname AS fkcolumn_name, 1885 pos.n AS key_seq, 1886 CASE con.confupdtype 1887 WHEN 'c' THEN 0 1888 WHEN 'n' THEN 2 1889 WHEN 'd' THEN 4 1890 WHEN 'r' THEN 1 1891 WHEN 'a' THEN 3 1892 ELSE NULL 1893 END 1894 AS update_rule, 1895 CASE con.confdeltype 1896 WHEN 'c' THEN 0 1897 WHEN 'n' THEN 2 1898 WHEN 'd' THEN 4 1899 WHEN 'r' THEN 1 1900 WHEN 'a' THEN 3 1901 ELSE NULL 1902 END 1903 AS delete_rule, 1904 con.conname AS fk_name, 1905 pkic.relname AS pk_name, 1906 CASE 1907 WHEN con.condeferrable AND con.condeferred 1908 THEN 5 1909 WHEN con.condeferrable THEN 6 1910 ELSE 7 1911 END 1912 AS deferrability 1913 FROM 1914 pg_catalog.pg_namespace AS pkn, 1915 pg_catalog.pg_class AS pkc, 1916 pg_catalog.pg_attribute AS pka, 1917 pg_catalog.pg_namespace AS fkn, 1918 pg_catalog.pg_class AS fkc, 1919 pg_catalog.pg_attribute AS fka, 1920 pg_catalog.pg_constraint AS con, 1921 pg_catalog.generate_series(1, 32) 1922 AS pos (n), 1923 pg_catalog.pg_depend AS dep, 1924 pg_catalog.pg_class AS pkic 1925 WHERE 1926 pkn.oid = pkc.relnamespace 1927 AND pkc.oid = pka.attrelid 1928 AND pka.attnum = con.confkey[pos.n] 1929 AND con.confrelid = pkc.oid 1930 AND fkn.oid = fkc.relnamespace 1931 AND fkc.oid = fka.attrelid 1932 AND fka.attnum = con.conkey[pos.n] 1933 AND con.conrelid = fkc.oid 1934 AND con.contype = 'f' 1935 AND con.oid = dep.objid 1936 AND pkic.oid = dep.refobjid 1937 AND pkic.relkind = 'i' 1938 AND dep.classid 1939 = 'pg_constraint'::REGCLASS::OID 1940 AND dep.refclassid 1941 = 'pg_class'::REGCLASS::OID 1942 AND fkn.nspname = 'public' 1943 AND fkc.relname = 'orders' 1944 ORDER BY 1945 pkn.nspname, pkc.relname, con.conname, pos.n 1946 1947 49: 1948 ------------------------------------------------- 1949 SELECT 1950 NULL::STRING AS pktable_cat, 1951 pkn.nspname AS pktable_schem, 1952 pkc.relname AS pktable_name, 1953 pka.attname AS pkcolumn_name, 1954 NULL::STRING AS fktable_cat, 1955 fkn.nspname AS fktable_schem, 1956 fkc.relname AS fktable_name, 1957 fka.attname AS fkcolumn_name, 1958 pos.n AS key_seq, 1959 CASE con.confupdtype 1960 WHEN 'c' THEN 0 1961 WHEN 'n' THEN 2 1962 WHEN 'd' THEN 4 1963 WHEN 'r' THEN 1 1964 WHEN 'a' THEN 3 1965 ELSE NULL 1966 END 1967 AS update_rule, 1968 CASE con.confdeltype 1969 WHEN 'c' THEN 0 1970 WHEN 'n' THEN 2 1971 WHEN 'd' THEN 4 1972 WHEN 'r' THEN 1 1973 WHEN 'a' THEN 3 1974 ELSE NULL 1975 END 1976 AS delete_rule, 1977 con.conname AS fk_name, 1978 pkic.relname AS pk_name, 1979 CASE 1980 WHEN con.condeferrable AND con.condeferred 1981 THEN 5 1982 WHEN con.condeferrable THEN 6 1983 ELSE 7 1984 END 1985 AS deferrability 1986 FROM 1987 pg_catalog.pg_namespace AS pkn, 1988 pg_catalog.pg_class AS pkc, 1989 pg_catalog.pg_attribute AS pka, 1990 pg_catalog.pg_namespace AS fkn, 1991 pg_catalog.pg_class AS fkc, 1992 pg_catalog.pg_attribute AS fka, 1993 pg_catalog.pg_constraint AS con, 1994 pg_catalog.generate_series(1, 32) AS pos (n), 1995 pg_catalog.pg_depend AS dep, 1996 pg_catalog.pg_class AS pkic 1997 WHERE 1998 pkn.oid = pkc.relnamespace 1999 AND pkc.oid = pka.attrelid 2000 AND pka.attnum = con.confkey[pos.n] 2001 AND con.confrelid = pkc.oid 2002 AND fkn.oid = fkc.relnamespace 2003 AND fkc.oid = fka.attrelid 2004 AND fka.attnum = con.conkey[pos.n] 2005 AND con.conrelid = fkc.oid 2006 AND con.contype = 'f' 2007 AND con.oid = dep.objid 2008 AND pkic.oid = dep.refobjid 2009 AND pkic.relkind = 'i' 2010 AND dep.classid 2011 = 'pg_constraint'::REGCLASS::OID 2012 AND dep.refclassid 2013 = 'pg_class'::REGCLASS::OID 2014 AND fkn.nspname = 'public' 2015 AND fkc.relname = 'orders' 2016 ORDER BY 2017 pkn.nspname, pkc.relname, con.conname, pos.n 2018 2019 50: 2020 -------------------------------------------------- 2021 SELECT 2022 NULL::STRING AS pktable_cat, 2023 pkn.nspname AS pktable_schem, 2024 pkc.relname AS pktable_name, 2025 pka.attname AS pkcolumn_name, 2026 NULL::STRING AS fktable_cat, 2027 fkn.nspname AS fktable_schem, 2028 fkc.relname AS fktable_name, 2029 fka.attname AS fkcolumn_name, 2030 pos.n AS key_seq, 2031 CASE con.confupdtype 2032 WHEN 'c' THEN 0 2033 WHEN 'n' THEN 2 2034 WHEN 'd' THEN 4 2035 WHEN 'r' THEN 1 2036 WHEN 'a' THEN 3 2037 ELSE NULL 2038 END 2039 AS update_rule, 2040 CASE con.confdeltype 2041 WHEN 'c' THEN 0 2042 WHEN 'n' THEN 2 2043 WHEN 'd' THEN 4 2044 WHEN 'r' THEN 1 2045 WHEN 'a' THEN 3 2046 ELSE NULL 2047 END 2048 AS delete_rule, 2049 con.conname AS fk_name, 2050 pkic.relname AS pk_name, 2051 CASE 2052 WHEN con.condeferrable AND con.condeferred 2053 THEN 5 2054 WHEN con.condeferrable THEN 6 2055 ELSE 7 2056 END 2057 AS deferrability 2058 FROM 2059 pg_catalog.pg_namespace AS pkn, 2060 pg_catalog.pg_class AS pkc, 2061 pg_catalog.pg_attribute AS pka, 2062 pg_catalog.pg_namespace AS fkn, 2063 pg_catalog.pg_class AS fkc, 2064 pg_catalog.pg_attribute AS fka, 2065 pg_catalog.pg_constraint AS con, 2066 pg_catalog.generate_series(1, 32) AS pos (n), 2067 pg_catalog.pg_depend AS dep, 2068 pg_catalog.pg_class AS pkic 2069 WHERE 2070 pkn.oid = pkc.relnamespace 2071 AND pkc.oid = pka.attrelid 2072 AND pka.attnum = con.confkey[pos.n] 2073 AND con.confrelid = pkc.oid 2074 AND fkn.oid = fkc.relnamespace 2075 AND fkc.oid = fka.attrelid 2076 AND fka.attnum = con.conkey[pos.n] 2077 AND con.conrelid = fkc.oid 2078 AND con.contype = 'f' 2079 AND con.oid = dep.objid 2080 AND pkic.oid = dep.refobjid 2081 AND pkic.relkind = 'i' 2082 AND dep.classid 2083 = 'pg_constraint'::REGCLASS::OID 2084 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2085 AND fkn.nspname = 'public' 2086 AND fkc.relname = 'orders' 2087 ORDER BY 2088 pkn.nspname, pkc.relname, con.conname, pos.n 2089 2090 52: 2091 ---------------------------------------------------- 2092 SELECT 2093 NULL::STRING AS pktable_cat, 2094 pkn.nspname AS pktable_schem, 2095 pkc.relname AS pktable_name, 2096 pka.attname AS pkcolumn_name, 2097 NULL::STRING AS fktable_cat, 2098 fkn.nspname AS fktable_schem, 2099 fkc.relname AS fktable_name, 2100 fka.attname AS fkcolumn_name, 2101 pos.n AS key_seq, 2102 CASE con.confupdtype 2103 WHEN 'c' THEN 0 2104 WHEN 'n' THEN 2 2105 WHEN 'd' THEN 4 2106 WHEN 'r' THEN 1 2107 WHEN 'a' THEN 3 2108 ELSE NULL 2109 END 2110 AS update_rule, 2111 CASE con.confdeltype 2112 WHEN 'c' THEN 0 2113 WHEN 'n' THEN 2 2114 WHEN 'd' THEN 4 2115 WHEN 'r' THEN 1 2116 WHEN 'a' THEN 3 2117 ELSE NULL 2118 END 2119 AS delete_rule, 2120 con.conname AS fk_name, 2121 pkic.relname AS pk_name, 2122 CASE 2123 WHEN con.condeferrable AND con.condeferred 2124 THEN 5 2125 WHEN con.condeferrable THEN 6 2126 ELSE 7 2127 END 2128 AS deferrability 2129 FROM 2130 pg_catalog.pg_namespace AS pkn, 2131 pg_catalog.pg_class AS pkc, 2132 pg_catalog.pg_attribute AS pka, 2133 pg_catalog.pg_namespace AS fkn, 2134 pg_catalog.pg_class AS fkc, 2135 pg_catalog.pg_attribute AS fka, 2136 pg_catalog.pg_constraint AS con, 2137 pg_catalog.generate_series(1, 32) AS pos (n), 2138 pg_catalog.pg_depend AS dep, 2139 pg_catalog.pg_class AS pkic 2140 WHERE 2141 pkn.oid = pkc.relnamespace 2142 AND pkc.oid = pka.attrelid 2143 AND pka.attnum = con.confkey[pos.n] 2144 AND con.confrelid = pkc.oid 2145 AND fkn.oid = fkc.relnamespace 2146 AND fkc.oid = fka.attrelid 2147 AND fka.attnum = con.conkey[pos.n] 2148 AND con.conrelid = fkc.oid 2149 AND con.contype = 'f' 2150 AND con.oid = dep.objid 2151 AND pkic.oid = dep.refobjid 2152 AND pkic.relkind = 'i' 2153 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2154 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2155 AND fkn.nspname = 'public' 2156 AND fkc.relname = 'orders' 2157 ORDER BY 2158 pkn.nspname, pkc.relname, con.conname, pos.n 2159 2160 53: 2161 ----------------------------------------------------- 2162 SELECT 2163 NULL::STRING AS pktable_cat, 2164 pkn.nspname AS pktable_schem, 2165 pkc.relname AS pktable_name, 2166 pka.attname AS pkcolumn_name, 2167 NULL::STRING AS fktable_cat, 2168 fkn.nspname AS fktable_schem, 2169 fkc.relname AS fktable_name, 2170 fka.attname AS fkcolumn_name, 2171 pos.n AS key_seq, 2172 CASE con.confupdtype 2173 WHEN 'c' THEN 0 2174 WHEN 'n' THEN 2 2175 WHEN 'd' THEN 4 2176 WHEN 'r' THEN 1 2177 WHEN 'a' THEN 3 2178 ELSE NULL 2179 END 2180 AS update_rule, 2181 CASE con.confdeltype 2182 WHEN 'c' THEN 0 2183 WHEN 'n' THEN 2 2184 WHEN 'd' THEN 4 2185 WHEN 'r' THEN 1 2186 WHEN 'a' THEN 3 2187 ELSE NULL 2188 END 2189 AS delete_rule, 2190 con.conname AS fk_name, 2191 pkic.relname AS pk_name, 2192 CASE 2193 WHEN con.condeferrable AND con.condeferred THEN 5 2194 WHEN con.condeferrable THEN 6 2195 ELSE 7 2196 END 2197 AS deferrability 2198 FROM 2199 pg_catalog.pg_namespace AS pkn, 2200 pg_catalog.pg_class AS pkc, 2201 pg_catalog.pg_attribute AS pka, 2202 pg_catalog.pg_namespace AS fkn, 2203 pg_catalog.pg_class AS fkc, 2204 pg_catalog.pg_attribute AS fka, 2205 pg_catalog.pg_constraint AS con, 2206 pg_catalog.generate_series(1, 32) AS pos (n), 2207 pg_catalog.pg_depend AS dep, 2208 pg_catalog.pg_class AS pkic 2209 WHERE 2210 pkn.oid = pkc.relnamespace 2211 AND pkc.oid = pka.attrelid 2212 AND pka.attnum = con.confkey[pos.n] 2213 AND con.confrelid = pkc.oid 2214 AND fkn.oid = fkc.relnamespace 2215 AND fkc.oid = fka.attrelid 2216 AND fka.attnum = con.conkey[pos.n] 2217 AND con.conrelid = fkc.oid 2218 AND con.contype = 'f' 2219 AND con.oid = dep.objid 2220 AND pkic.oid = dep.refobjid 2221 AND pkic.relkind = 'i' 2222 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2223 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2224 AND fkn.nspname = 'public' 2225 AND fkc.relname = 'orders' 2226 ORDER BY 2227 pkn.nspname, pkc.relname, con.conname, pos.n 2228 2229 116: 2230 -------------------------------------------------------------------------------------------------------------------- 2231 SELECT 2232 NULL::STRING AS pktable_cat, 2233 pkn.nspname AS pktable_schem, 2234 pkc.relname AS pktable_name, 2235 pka.attname AS pkcolumn_name, 2236 NULL::STRING AS fktable_cat, 2237 fkn.nspname AS fktable_schem, 2238 fkc.relname AS fktable_name, 2239 fka.attname AS fkcolumn_name, 2240 pos.n AS key_seq, 2241 CASE con.confupdtype 2242 WHEN 'c' THEN 0 2243 WHEN 'n' THEN 2 2244 WHEN 'd' THEN 4 2245 WHEN 'r' THEN 1 2246 WHEN 'a' THEN 3 2247 ELSE NULL 2248 END 2249 AS update_rule, 2250 CASE con.confdeltype 2251 WHEN 'c' THEN 0 2252 WHEN 'n' THEN 2 2253 WHEN 'd' THEN 4 2254 WHEN 'r' THEN 1 2255 WHEN 'a' THEN 3 2256 ELSE NULL 2257 END 2258 AS delete_rule, 2259 con.conname AS fk_name, 2260 pkic.relname AS pk_name, 2261 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2262 FROM 2263 pg_catalog.pg_namespace AS pkn, 2264 pg_catalog.pg_class AS pkc, 2265 pg_catalog.pg_attribute AS pka, 2266 pg_catalog.pg_namespace AS fkn, 2267 pg_catalog.pg_class AS fkc, 2268 pg_catalog.pg_attribute AS fka, 2269 pg_catalog.pg_constraint AS con, 2270 pg_catalog.generate_series(1, 32) AS pos (n), 2271 pg_catalog.pg_depend AS dep, 2272 pg_catalog.pg_class AS pkic 2273 WHERE 2274 pkn.oid = pkc.relnamespace 2275 AND pkc.oid = pka.attrelid 2276 AND pka.attnum = con.confkey[pos.n] 2277 AND con.confrelid = pkc.oid 2278 AND fkn.oid = fkc.relnamespace 2279 AND fkc.oid = fka.attrelid 2280 AND fka.attnum = con.conkey[pos.n] 2281 AND con.conrelid = fkc.oid 2282 AND con.contype = 'f' 2283 AND con.oid = dep.objid 2284 AND pkic.oid = dep.refobjid 2285 AND pkic.relkind = 'i' 2286 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2287 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2288 AND fkn.nspname = 'public' 2289 AND fkc.relname = 'orders' 2290 ORDER BY 2291 pkn.nspname, pkc.relname, con.conname, pos.n 2292 2293 134: 2294 -------------------------------------------------------------------------------------------------------------------------------------- 2295 SELECT 2296 NULL::STRING AS pktable_cat, 2297 pkn.nspname AS pktable_schem, 2298 pkc.relname AS pktable_name, 2299 pka.attname AS pkcolumn_name, 2300 NULL::STRING AS fktable_cat, 2301 fkn.nspname AS fktable_schem, 2302 fkc.relname AS fktable_name, 2303 fka.attname AS fkcolumn_name, 2304 pos.n AS key_seq, 2305 CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS update_rule, 2306 CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS delete_rule, 2307 con.conname AS fk_name, 2308 pkic.relname AS pk_name, 2309 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2310 FROM 2311 pg_catalog.pg_namespace AS pkn, 2312 pg_catalog.pg_class AS pkc, 2313 pg_catalog.pg_attribute AS pka, 2314 pg_catalog.pg_namespace AS fkn, 2315 pg_catalog.pg_class AS fkc, 2316 pg_catalog.pg_attribute AS fka, 2317 pg_catalog.pg_constraint AS con, 2318 pg_catalog.generate_series(1, 32) AS pos (n), 2319 pg_catalog.pg_depend AS dep, 2320 pg_catalog.pg_class AS pkic 2321 WHERE 2322 pkn.oid = pkc.relnamespace 2323 AND pkc.oid = pka.attrelid 2324 AND pka.attnum = con.confkey[pos.n] 2325 AND con.confrelid = pkc.oid 2326 AND fkn.oid = fkc.relnamespace 2327 AND fkc.oid = fka.attrelid 2328 AND fka.attnum = con.conkey[pos.n] 2329 AND con.conrelid = fkc.oid 2330 AND con.contype = 'f' 2331 AND con.oid = dep.objid 2332 AND pkic.oid = dep.refobjid 2333 AND pkic.relkind = 'i' 2334 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2335 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2336 AND fkn.nspname = 'public' 2337 AND fkc.relname = 'orders' 2338 ORDER BY 2339 pkn.nspname, pkc.relname, con.conname, pos.n 2340 2341 323: 2342 ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2343 SELECT 2344 NULL::STRING AS pktable_cat, 2345 pkn.nspname AS pktable_schem, 2346 pkc.relname AS pktable_name, 2347 pka.attname AS pkcolumn_name, 2348 NULL::STRING AS fktable_cat, 2349 fkn.nspname AS fktable_schem, 2350 fkc.relname AS fktable_name, 2351 fka.attname AS fkcolumn_name, 2352 pos.n AS key_seq, 2353 CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS update_rule, 2354 CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS delete_rule, 2355 con.conname AS fk_name, 2356 pkic.relname AS pk_name, 2357 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2358 FROM 2359 pg_catalog.pg_namespace AS pkn, pg_catalog.pg_class AS pkc, pg_catalog.pg_attribute AS pka, pg_catalog.pg_namespace AS fkn, pg_catalog.pg_class AS fkc, pg_catalog.pg_attribute AS fka, pg_catalog.pg_constraint AS con, pg_catalog.generate_series(1, 32) AS pos (n), pg_catalog.pg_depend AS dep, pg_catalog.pg_class AS pkic 2360 WHERE 2361 pkn.oid = pkc.relnamespace 2362 AND pkc.oid = pka.attrelid 2363 AND pka.attnum = con.confkey[pos.n] 2364 AND con.confrelid = pkc.oid 2365 AND fkn.oid = fkc.relnamespace 2366 AND fkc.oid = fka.attrelid 2367 AND fka.attnum = con.conkey[pos.n] 2368 AND con.conrelid = fkc.oid 2369 AND con.contype = 'f' 2370 AND con.oid = dep.objid 2371 AND pkic.oid = dep.refobjid 2372 AND pkic.relkind = 'i' 2373 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2374 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2375 AND fkn.nspname = 'public' 2376 AND fkc.relname = 'orders' 2377 ORDER BY 2378 pkn.nspname, pkc.relname, con.conname, pos.n 2379 2380 488: 2381 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2382 SELECT 2383 NULL::STRING AS pktable_cat, 2384 pkn.nspname AS pktable_schem, 2385 pkc.relname AS pktable_name, 2386 pka.attname AS pkcolumn_name, 2387 NULL::STRING AS fktable_cat, 2388 fkn.nspname AS fktable_schem, 2389 fkc.relname AS fktable_name, 2390 fka.attname AS fkcolumn_name, 2391 pos.n AS key_seq, 2392 CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS update_rule, 2393 CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS delete_rule, 2394 con.conname AS fk_name, 2395 pkic.relname AS pk_name, 2396 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2397 FROM 2398 pg_catalog.pg_namespace AS pkn, pg_catalog.pg_class AS pkc, pg_catalog.pg_attribute AS pka, pg_catalog.pg_namespace AS fkn, pg_catalog.pg_class AS fkc, pg_catalog.pg_attribute AS fka, pg_catalog.pg_constraint AS con, pg_catalog.generate_series(1, 32) AS pos (n), pg_catalog.pg_depend AS dep, pg_catalog.pg_class AS pkic 2399 WHERE 2400 pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::REGCLASS::OID AND dep.refclassid = 'pg_class'::REGCLASS::OID AND fkn.nspname = 'public' AND fkc.relname = 'orders' 2401 ORDER BY 2402 pkn.nspname, pkc.relname, con.conname, pos.n 2403 2404 681: 2405 --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2406 SELECT 2407 NULL::STRING AS pktable_cat, pkn.nspname AS pktable_schem, pkc.relname AS pktable_name, pka.attname AS pkcolumn_name, NULL::STRING AS fktable_cat, fkn.nspname AS fktable_schem, fkc.relname AS fktable_name, fka.attname AS fkcolumn_name, pos.n AS key_seq, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS update_rule, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS delete_rule, con.conname AS fk_name, pkic.relname AS pk_name, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2408 FROM 2409 pg_catalog.pg_namespace AS pkn, pg_catalog.pg_class AS pkc, pg_catalog.pg_attribute AS pka, pg_catalog.pg_namespace AS fkn, pg_catalog.pg_class AS fkc, pg_catalog.pg_attribute AS fka, pg_catalog.pg_constraint AS con, pg_catalog.generate_series(1, 32) AS pos (n), pg_catalog.pg_depend AS dep, pg_catalog.pg_class AS pkic 2410 WHERE 2411 pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::REGCLASS::OID AND dep.refclassid = 'pg_class'::REGCLASS::OID AND fkn.nspname = 'public' AND fkc.relname = 'orders' 2412 ORDER BY 2413 pkn.nspname, pkc.relname, con.conname, pos.n 2414 2415 1554: 2416 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2417 SELECT NULL::STRING AS pktable_cat, pkn.nspname AS pktable_schem, pkc.relname AS pktable_name, pka.attname AS pkcolumn_name, NULL::STRING AS fktable_cat, fkn.nspname AS fktable_schem, fkc.relname AS fktable_name, fka.attname AS fkcolumn_name, pos.n AS key_seq, CASE con.confupdtype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS update_rule, CASE con.confdeltype WHEN 'c' THEN 0 WHEN 'n' THEN 2 WHEN 'd' THEN 4 WHEN 'r' THEN 1 WHEN 'a' THEN 3 ELSE NULL END AS delete_rule, con.conname AS fk_name, pkic.relname AS pk_name, CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability FROM pg_catalog.pg_namespace AS pkn, pg_catalog.pg_class AS pkc, pg_catalog.pg_attribute AS pka, pg_catalog.pg_namespace AS fkn, pg_catalog.pg_class AS fkc, pg_catalog.pg_attribute AS fka, pg_catalog.pg_constraint AS con, pg_catalog.generate_series(1, 32) AS pos (n), pg_catalog.pg_depend AS dep, pg_catalog.pg_class AS pkic WHERE pkn.oid = pkc.relnamespace AND pkc.oid = pka.attrelid AND pka.attnum = con.confkey[pos.n] AND con.confrelid = pkc.oid AND fkn.oid = fkc.relnamespace AND fkc.oid = fka.attrelid AND fka.attnum = con.conkey[pos.n] AND con.conrelid = fkc.oid AND con.contype = 'f' AND con.oid = dep.objid AND pkic.oid = dep.refobjid AND pkic.relkind = 'i' AND dep.classid = 'pg_constraint'::REGCLASS::OID AND dep.refclassid = 'pg_class'::REGCLASS::OID AND fkn.nspname = 'public' AND fkc.relname = 'orders' ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2418 2419