github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/sem/tree/testdata/pretty/join1.align-only.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 8: 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 AS deferrability 192 FROM 193 pg_catalog.pg_namespace 194 AS pkn, 195 pg_catalog.pg_class 196 AS pkc, 197 pg_catalog.pg_attribute 198 AS pka, 199 pg_catalog.pg_namespace 200 AS fkn, 201 pg_catalog.pg_class 202 AS fkc, 203 pg_catalog.pg_attribute 204 AS fka, 205 pg_catalog.pg_constraint 206 AS con, 207 pg_catalog.generate_series( 208 1, 209 32 210 ) 211 AS pos 212 ( 213 n 214 ), 215 pg_catalog.pg_depend 216 AS dep, 217 pg_catalog.pg_class 218 AS pkic 219 WHERE 220 pkn.oid 221 = pkc.relnamespace 222 AND pkc.oid 223 = pka.attrelid 224 AND pka.attnum 225 = con.confkey[pos.n] 226 AND con.confrelid 227 = pkc.oid 228 AND fkn.oid 229 = fkc.relnamespace 230 AND fkc.oid 231 = fka.attrelid 232 AND fka.attnum 233 = con.conkey[pos.n] 234 AND con.conrelid 235 = fkc.oid 236 AND con.contype 237 = 'f' 238 AND con.oid 239 = dep.objid 240 AND pkic.oid 241 = dep.refobjid 242 AND pkic.relkind 243 = 'i' 244 AND dep.classid 245 = 'pg_constraint'::REGCLASS::OID 246 AND dep.refclassid 247 = 'pg_class'::REGCLASS::OID 248 AND fkn.nspname 249 = 'public' 250 AND fkc.relname 251 = 'orders' 252 ORDER BY 253 pkn.nspname, 254 pkc.relname, 255 con.conname, 256 pos.n 257 258 16: 259 ---------------- 260 SELECT 261 NULL::STRING 262 AS pktable_cat, 263 pkn.nspname 264 AS pktable_schem, 265 pkc.relname 266 AS pktable_name, 267 pka.attname 268 AS pkcolumn_name, 269 NULL::STRING 270 AS fktable_cat, 271 fkn.nspname 272 AS fktable_schem, 273 fkc.relname 274 AS fktable_name, 275 fka.attname 276 AS fkcolumn_name, 277 pos.n 278 AS key_seq, 279 CASE con.confupdtype 280 WHEN 'c' 281 THEN 0 282 WHEN 'n' 283 THEN 2 284 WHEN 'd' 285 THEN 4 286 WHEN 'r' 287 THEN 1 288 WHEN 'a' 289 THEN 3 290 ELSE NULL 291 END 292 AS update_rule, 293 CASE con.confdeltype 294 WHEN 'c' 295 THEN 0 296 WHEN 'n' 297 THEN 2 298 WHEN 'd' 299 THEN 4 300 WHEN 'r' 301 THEN 1 302 WHEN 'a' 303 THEN 3 304 ELSE NULL 305 END 306 AS delete_rule, 307 con.conname 308 AS fk_name, 309 pkic.relname 310 AS pk_name, 311 CASE 312 WHEN con.condeferrable 313 AND con.condeferred 314 THEN 5 315 WHEN con.condeferrable 316 THEN 6 317 ELSE 7 318 END AS deferrability 319 FROM 320 pg_catalog.pg_namespace 321 AS pkn, 322 pg_catalog.pg_class 323 AS pkc, 324 pg_catalog.pg_attribute 325 AS pka, 326 pg_catalog.pg_namespace 327 AS fkn, 328 pg_catalog.pg_class 329 AS fkc, 330 pg_catalog.pg_attribute 331 AS fka, 332 pg_catalog.pg_constraint 333 AS con, 334 pg_catalog.generate_series( 335 1, 336 32 337 ) 338 AS pos ( 339 n 340 ), 341 pg_catalog.pg_depend 342 AS dep, 343 pg_catalog.pg_class 344 AS pkic 345 WHERE 346 pkn.oid 347 = pkc.relnamespace 348 AND pkc.oid 349 = pka.attrelid 350 AND pka.attnum 351 = con.confkey[pos.n] 352 AND con.confrelid 353 = pkc.oid 354 AND fkn.oid 355 = fkc.relnamespace 356 AND fkc.oid 357 = fka.attrelid 358 AND fka.attnum 359 = con.conkey[pos.n] 360 AND con.conrelid 361 = fkc.oid 362 AND con.contype 363 = 'f' 364 AND con.oid 365 = dep.objid 366 AND pkic.oid 367 = dep.refobjid 368 AND pkic.relkind 369 = 'i' 370 AND dep.classid 371 = 'pg_constraint'::REGCLASS::OID 372 AND dep.refclassid 373 = 'pg_class'::REGCLASS::OID 374 AND fkn.nspname 375 = 'public' 376 AND fkc.relname 377 = 'orders' 378 ORDER BY 379 pkn.nspname, 380 pkc.relname, 381 con.conname, 382 pos.n 383 384 19: 385 ------------------- 386 SELECT 387 NULL::STRING 388 AS pktable_cat, 389 pkn.nspname 390 AS pktable_schem, 391 pkc.relname 392 AS pktable_name, 393 pka.attname 394 AS pkcolumn_name, 395 NULL::STRING 396 AS fktable_cat, 397 fkn.nspname 398 AS fktable_schem, 399 fkc.relname 400 AS fktable_name, 401 fka.attname 402 AS fkcolumn_name, 403 pos.n 404 AS key_seq, 405 CASE con.confupdtype 406 WHEN 'c' THEN 0 407 WHEN 'n' THEN 2 408 WHEN 'd' THEN 4 409 WHEN 'r' THEN 1 410 WHEN 'a' THEN 3 411 ELSE NULL 412 END 413 AS update_rule, 414 CASE con.confdeltype 415 WHEN 'c' THEN 0 416 WHEN 'n' THEN 2 417 WHEN 'd' THEN 4 418 WHEN 'r' THEN 1 419 WHEN 'a' THEN 3 420 ELSE NULL 421 END 422 AS delete_rule, 423 con.conname 424 AS fk_name, 425 pkic.relname 426 AS pk_name, 427 CASE 428 WHEN con.condeferrable 429 AND con.condeferred 430 THEN 5 431 WHEN con.condeferrable 432 THEN 6 433 ELSE 7 434 END AS deferrability 435 FROM 436 pg_catalog.pg_namespace 437 AS pkn, 438 pg_catalog.pg_class 439 AS pkc, 440 pg_catalog.pg_attribute 441 AS pka, 442 pg_catalog.pg_namespace 443 AS fkn, 444 pg_catalog.pg_class 445 AS fkc, 446 pg_catalog.pg_attribute 447 AS fka, 448 pg_catalog.pg_constraint 449 AS con, 450 pg_catalog.generate_series( 451 1, 452 32 453 ) 454 AS pos (n), 455 pg_catalog.pg_depend 456 AS dep, 457 pg_catalog.pg_class 458 AS pkic 459 WHERE 460 pkn.oid 461 = pkc.relnamespace 462 AND pkc.oid 463 = pka.attrelid 464 AND pka.attnum 465 = con.confkey[pos.n] 466 AND con.confrelid 467 = pkc.oid 468 AND fkn.oid 469 = fkc.relnamespace 470 AND fkc.oid 471 = fka.attrelid 472 AND fka.attnum 473 = con.conkey[pos.n] 474 AND con.conrelid 475 = fkc.oid 476 AND con.contype 477 = 'f' 478 AND con.oid 479 = dep.objid 480 AND pkic.oid 481 = dep.refobjid 482 AND pkic.relkind 483 = 'i' 484 AND dep.classid 485 = 'pg_constraint'::REGCLASS::OID 486 AND dep.refclassid 487 = 'pg_class'::REGCLASS::OID 488 AND fkn.nspname 489 = 'public' 490 AND fkc.relname 491 = 'orders' 492 ORDER BY 493 pkn.nspname, 494 pkc.relname, 495 con.conname, 496 pos.n 497 498 21: 499 --------------------- 500 SELECT NULL::STRING 501 AS pktable_cat, 502 pkn.nspname 503 AS pktable_schem, 504 pkc.relname 505 AS pktable_name, 506 pka.attname 507 AS pkcolumn_name, 508 NULL::STRING 509 AS fktable_cat, 510 fkn.nspname 511 AS fktable_schem, 512 fkc.relname 513 AS fktable_name, 514 fka.attname 515 AS fkcolumn_name, 516 pos.n 517 AS key_seq, 518 CASE con.confupdtype 519 WHEN 'c' 520 THEN 0 521 WHEN 'n' 522 THEN 2 523 WHEN 'd' 524 THEN 4 525 WHEN 'r' 526 THEN 1 527 WHEN 'a' 528 THEN 3 529 ELSE NULL 530 END 531 AS update_rule, 532 CASE con.confdeltype 533 WHEN 'c' 534 THEN 0 535 WHEN 'n' 536 THEN 2 537 WHEN 'd' 538 THEN 4 539 WHEN 'r' 540 THEN 1 541 WHEN 'a' 542 THEN 3 543 ELSE NULL 544 END 545 AS delete_rule, 546 con.conname 547 AS fk_name, 548 pkic.relname 549 AS pk_name, 550 CASE 551 WHEN con.condeferrable 552 AND con.condeferred 553 THEN 5 554 WHEN con.condeferrable 555 THEN 6 556 ELSE 7 557 END AS deferrability 558 FROM pg_catalog.pg_namespace 559 AS pkn, 560 pg_catalog.pg_class 561 AS pkc, 562 pg_catalog.pg_attribute 563 AS pka, 564 pg_catalog.pg_namespace 565 AS fkn, 566 pg_catalog.pg_class 567 AS fkc, 568 pg_catalog.pg_attribute 569 AS fka, 570 pg_catalog.pg_constraint 571 AS con, 572 pg_catalog.generate_series( 573 1, 574 32 575 ) 576 AS pos ( 577 n 578 ), 579 pg_catalog.pg_depend 580 AS dep, 581 pg_catalog.pg_class 582 AS pkic 583 WHERE pkn.oid 584 = pkc.relnamespace 585 AND pkc.oid 586 = pka.attrelid 587 AND pka.attnum 588 = con.confkey[pos.n] 589 AND con.confrelid 590 = pkc.oid 591 AND fkn.oid 592 = fkc.relnamespace 593 AND fkc.oid 594 = fka.attrelid 595 AND fka.attnum 596 = con.conkey[pos.n] 597 AND con.conrelid 598 = fkc.oid 599 AND con.contype 600 = 'f' 601 AND con.oid 602 = dep.objid 603 AND pkic.oid 604 = dep.refobjid 605 AND pkic.relkind 606 = 'i' 607 AND dep.classid 608 = 'pg_constraint'::REGCLASS::OID 609 AND dep.refclassid 610 = 'pg_class'::REGCLASS::OID 611 AND fkn.nspname 612 = 'public' 613 AND fkc.relname 614 = 'orders' 615 ORDER BY pkn.nspname, 616 pkc.relname, 617 con.conname, 618 pos.n 619 620 23: 621 ----------------------- 622 SELECT NULL::STRING 623 AS pktable_cat, 624 pkn.nspname 625 AS pktable_schem, 626 pkc.relname 627 AS pktable_name, 628 pka.attname 629 AS pkcolumn_name, 630 NULL::STRING 631 AS fktable_cat, 632 fkn.nspname 633 AS fktable_schem, 634 fkc.relname 635 AS fktable_name, 636 fka.attname 637 AS fkcolumn_name, 638 pos.n 639 AS key_seq, 640 CASE con.confupdtype 641 WHEN 'c' 642 THEN 0 643 WHEN 'n' 644 THEN 2 645 WHEN 'd' 646 THEN 4 647 WHEN 'r' 648 THEN 1 649 WHEN 'a' 650 THEN 3 651 ELSE NULL 652 END 653 AS update_rule, 654 CASE con.confdeltype 655 WHEN 'c' 656 THEN 0 657 WHEN 'n' 658 THEN 2 659 WHEN 'd' 660 THEN 4 661 WHEN 'r' 662 THEN 1 663 WHEN 'a' 664 THEN 3 665 ELSE NULL 666 END 667 AS delete_rule, 668 con.conname 669 AS fk_name, 670 pkic.relname 671 AS pk_name, 672 CASE 673 WHEN con.condeferrable 674 AND con.condeferred 675 THEN 5 676 WHEN con.condeferrable 677 THEN 6 678 ELSE 7 679 END AS deferrability 680 FROM pg_catalog.pg_namespace 681 AS pkn, 682 pg_catalog.pg_class 683 AS pkc, 684 pg_catalog.pg_attribute 685 AS pka, 686 pg_catalog.pg_namespace 687 AS fkn, 688 pg_catalog.pg_class 689 AS fkc, 690 pg_catalog.pg_attribute 691 AS fka, 692 pg_catalog.pg_constraint 693 AS con, 694 pg_catalog.generate_series( 695 1, 696 32 697 ) 698 AS pos (n), 699 pg_catalog.pg_depend 700 AS dep, 701 pg_catalog.pg_class 702 AS pkic 703 WHERE pkn.oid 704 = pkc.relnamespace 705 AND pkc.oid 706 = pka.attrelid 707 AND pka.attnum 708 = con.confkey[pos.n] 709 AND con.confrelid 710 = pkc.oid 711 AND fkn.oid 712 = fkc.relnamespace 713 AND fkc.oid 714 = fka.attrelid 715 AND fka.attnum 716 = con.conkey[pos.n] 717 AND con.conrelid 718 = fkc.oid 719 AND con.contype 720 = 'f' 721 AND con.oid 722 = dep.objid 723 AND pkic.oid 724 = dep.refobjid 725 AND pkic.relkind 726 = 'i' 727 AND dep.classid 728 = 'pg_constraint'::REGCLASS::OID 729 AND dep.refclassid 730 = 'pg_class'::REGCLASS::OID 731 AND fkn.nspname 732 = 'public' 733 AND fkc.relname 734 = 'orders' 735 ORDER BY pkn.nspname, 736 pkc.relname, 737 con.conname, 738 pos.n 739 740 24: 741 ------------------------ 742 SELECT NULL::STRING 743 AS pktable_cat, 744 pkn.nspname 745 AS pktable_schem, 746 pkc.relname 747 AS pktable_name, 748 pka.attname 749 AS pkcolumn_name, 750 NULL::STRING 751 AS fktable_cat, 752 fkn.nspname 753 AS fktable_schem, 754 fkc.relname 755 AS fktable_name, 756 fka.attname 757 AS fkcolumn_name, 758 pos.n 759 AS key_seq, 760 CASE con.confupdtype 761 WHEN 'c' THEN 0 762 WHEN 'n' THEN 2 763 WHEN 'd' THEN 4 764 WHEN 'r' THEN 1 765 WHEN 'a' THEN 3 766 ELSE NULL 767 END 768 AS update_rule, 769 CASE con.confdeltype 770 WHEN 'c' THEN 0 771 WHEN 'n' THEN 2 772 WHEN 'd' THEN 4 773 WHEN 'r' THEN 1 774 WHEN 'a' THEN 3 775 ELSE NULL 776 END 777 AS delete_rule, 778 con.conname 779 AS fk_name, 780 pkic.relname 781 AS pk_name, 782 CASE 783 WHEN con.condeferrable 784 AND con.condeferred 785 THEN 5 786 WHEN con.condeferrable 787 THEN 6 788 ELSE 7 789 END AS deferrability 790 FROM pg_catalog.pg_namespace 791 AS pkn, 792 pg_catalog.pg_class 793 AS pkc, 794 pg_catalog.pg_attribute 795 AS pka, 796 pg_catalog.pg_namespace 797 AS fkn, 798 pg_catalog.pg_class 799 AS fkc, 800 pg_catalog.pg_attribute 801 AS fka, 802 pg_catalog.pg_constraint 803 AS con, 804 pg_catalog.generate_series( 805 1, 806 32 807 ) 808 AS pos (n), 809 pg_catalog.pg_depend 810 AS dep, 811 pg_catalog.pg_class 812 AS pkic 813 WHERE pkn.oid 814 = pkc.relnamespace 815 AND pkc.oid 816 = pka.attrelid 817 AND pka.attnum 818 = con.confkey[pos.n] 819 AND con.confrelid 820 = pkc.oid 821 AND fkn.oid 822 = fkc.relnamespace 823 AND fkc.oid 824 = fka.attrelid 825 AND fka.attnum 826 = con.conkey[pos.n] 827 AND con.conrelid 828 = fkc.oid 829 AND con.contype 830 = 'f' 831 AND con.oid 832 = dep.objid 833 AND pkic.oid 834 = dep.refobjid 835 AND pkic.relkind 836 = 'i' 837 AND dep.classid 838 = 'pg_constraint'::REGCLASS::OID 839 AND dep.refclassid 840 = 'pg_class'::REGCLASS::OID 841 AND fkn.nspname 842 = 'public' 843 AND fkc.relname 844 = 'orders' 845 ORDER BY pkn.nspname, 846 pkc.relname, 847 con.conname, 848 pos.n 849 850 26: 851 -------------------------- 852 SELECT NULL::STRING 853 AS pktable_cat, 854 pkn.nspname 855 AS pktable_schem, 856 pkc.relname 857 AS pktable_name, 858 pka.attname 859 AS pkcolumn_name, 860 NULL::STRING 861 AS fktable_cat, 862 fkn.nspname 863 AS fktable_schem, 864 fkc.relname 865 AS fktable_name, 866 fka.attname 867 AS fkcolumn_name, 868 pos.n AS key_seq, 869 CASE con.confupdtype 870 WHEN 'c' THEN 0 871 WHEN 'n' THEN 2 872 WHEN 'd' THEN 4 873 WHEN 'r' THEN 1 874 WHEN 'a' THEN 3 875 ELSE NULL 876 END 877 AS update_rule, 878 CASE con.confdeltype 879 WHEN 'c' THEN 0 880 WHEN 'n' THEN 2 881 WHEN 'd' THEN 4 882 WHEN 'r' THEN 1 883 WHEN 'a' THEN 3 884 ELSE NULL 885 END 886 AS delete_rule, 887 con.conname 888 AS fk_name, 889 pkic.relname 890 AS pk_name, 891 CASE 892 WHEN con.condeferrable 893 AND con.condeferred 894 THEN 5 895 WHEN con.condeferrable 896 THEN 6 897 ELSE 7 898 END AS deferrability 899 FROM pg_catalog.pg_namespace 900 AS pkn, 901 pg_catalog.pg_class 902 AS pkc, 903 pg_catalog.pg_attribute 904 AS pka, 905 pg_catalog.pg_namespace 906 AS fkn, 907 pg_catalog.pg_class 908 AS fkc, 909 pg_catalog.pg_attribute 910 AS fka, 911 pg_catalog.pg_constraint 912 AS con, 913 pg_catalog.generate_series( 914 1, 915 32 916 ) 917 AS pos (n), 918 pg_catalog.pg_depend 919 AS dep, 920 pg_catalog.pg_class 921 AS pkic 922 WHERE pkn.oid 923 = pkc.relnamespace 924 AND pkc.oid 925 = pka.attrelid 926 AND pka.attnum 927 = con.confkey[pos.n] 928 AND con.confrelid 929 = pkc.oid 930 AND fkn.oid 931 = fkc.relnamespace 932 AND fkc.oid 933 = fka.attrelid 934 AND fka.attnum 935 = con.conkey[pos.n] 936 AND con.conrelid 937 = fkc.oid 938 AND con.contype 939 = 'f' 940 AND con.oid 941 = dep.objid 942 AND pkic.oid 943 = dep.refobjid 944 AND pkic.relkind 945 = 'i' 946 AND dep.classid 947 = 'pg_constraint'::REGCLASS::OID 948 AND dep.refclassid 949 = 'pg_class'::REGCLASS::OID 950 AND fkn.nspname 951 = 'public' 952 AND fkc.relname 953 = 'orders' 954 ORDER BY pkn.nspname, 955 pkc.relname, 956 con.conname, 957 pos.n 958 959 29: 960 ----------------------------- 961 SELECT NULL::STRING 962 AS pktable_cat, 963 pkn.nspname 964 AS pktable_schem, 965 pkc.relname 966 AS pktable_name, 967 pka.attname 968 AS pkcolumn_name, 969 NULL::STRING 970 AS fktable_cat, 971 fkn.nspname 972 AS fktable_schem, 973 fkc.relname 974 AS fktable_name, 975 fka.attname 976 AS fkcolumn_name, 977 pos.n AS key_seq, 978 CASE con.confupdtype 979 WHEN 'c' THEN 0 980 WHEN 'n' THEN 2 981 WHEN 'd' THEN 4 982 WHEN 'r' THEN 1 983 WHEN 'a' THEN 3 984 ELSE NULL 985 END AS update_rule, 986 CASE con.confdeltype 987 WHEN 'c' THEN 0 988 WHEN 'n' THEN 2 989 WHEN 'd' THEN 4 990 WHEN 'r' THEN 1 991 WHEN 'a' THEN 3 992 ELSE NULL 993 END AS delete_rule, 994 con.conname 995 AS fk_name, 996 pkic.relname 997 AS pk_name, 998 CASE 999 WHEN con.condeferrable 1000 AND con.condeferred 1001 THEN 5 1002 WHEN con.condeferrable 1003 THEN 6 1004 ELSE 7 1005 END AS deferrability 1006 FROM pg_catalog.pg_namespace 1007 AS pkn, 1008 pg_catalog.pg_class 1009 AS pkc, 1010 pg_catalog.pg_attribute 1011 AS pka, 1012 pg_catalog.pg_namespace 1013 AS fkn, 1014 pg_catalog.pg_class 1015 AS fkc, 1016 pg_catalog.pg_attribute 1017 AS fka, 1018 pg_catalog.pg_constraint 1019 AS con, 1020 pg_catalog.generate_series( 1021 1, 1022 32 1023 ) 1024 AS pos (n), 1025 pg_catalog.pg_depend 1026 AS dep, 1027 pg_catalog.pg_class 1028 AS pkic 1029 WHERE pkn.oid 1030 = pkc.relnamespace 1031 AND pkc.oid 1032 = pka.attrelid 1033 AND pka.attnum 1034 = con.confkey[pos.n] 1035 AND con.confrelid 1036 = pkc.oid 1037 AND fkn.oid 1038 = fkc.relnamespace 1039 AND fkc.oid 1040 = fka.attrelid 1041 AND fka.attnum 1042 = con.conkey[pos.n] 1043 AND con.conrelid 1044 = fkc.oid 1045 AND con.contype 1046 = 'f' 1047 AND con.oid 1048 = dep.objid 1049 AND pkic.oid 1050 = dep.refobjid 1051 AND pkic.relkind 1052 = 'i' 1053 AND dep.classid 1054 = 'pg_constraint'::REGCLASS::OID 1055 AND dep.refclassid 1056 = 'pg_class'::REGCLASS::OID 1057 AND fkn.nspname 1058 = 'public' 1059 AND fkc.relname 1060 = 'orders' 1061 ORDER BY pkn.nspname, 1062 pkc.relname, 1063 con.conname, 1064 pos.n 1065 1066 30: 1067 ------------------------------ 1068 SELECT NULL::STRING 1069 AS pktable_cat, 1070 pkn.nspname 1071 AS pktable_schem, 1072 pkc.relname 1073 AS pktable_name, 1074 pka.attname 1075 AS pkcolumn_name, 1076 NULL::STRING 1077 AS fktable_cat, 1078 fkn.nspname 1079 AS fktable_schem, 1080 fkc.relname 1081 AS fktable_name, 1082 fka.attname 1083 AS fkcolumn_name, 1084 pos.n AS key_seq, 1085 CASE con.confupdtype 1086 WHEN 'c' THEN 0 1087 WHEN 'n' THEN 2 1088 WHEN 'd' THEN 4 1089 WHEN 'r' THEN 1 1090 WHEN 'a' THEN 3 1091 ELSE NULL 1092 END AS update_rule, 1093 CASE con.confdeltype 1094 WHEN 'c' THEN 0 1095 WHEN 'n' THEN 2 1096 WHEN 'd' THEN 4 1097 WHEN 'r' THEN 1 1098 WHEN 'a' THEN 3 1099 ELSE NULL 1100 END AS delete_rule, 1101 con.conname 1102 AS fk_name, 1103 pkic.relname 1104 AS pk_name, 1105 CASE 1106 WHEN con.condeferrable 1107 AND con.condeferred 1108 THEN 5 1109 WHEN con.condeferrable 1110 THEN 6 1111 ELSE 7 1112 END AS deferrability 1113 FROM pg_catalog.pg_namespace 1114 AS pkn, 1115 pg_catalog.pg_class 1116 AS pkc, 1117 pg_catalog.pg_attribute 1118 AS pka, 1119 pg_catalog.pg_namespace 1120 AS fkn, 1121 pg_catalog.pg_class 1122 AS fkc, 1123 pg_catalog.pg_attribute 1124 AS fka, 1125 pg_catalog.pg_constraint 1126 AS con, 1127 pg_catalog.generate_series( 1128 1, 1129 32 1130 ) 1131 AS pos (n), 1132 pg_catalog.pg_depend 1133 AS dep, 1134 pg_catalog.pg_class 1135 AS pkic 1136 WHERE pkn.oid 1137 = pkc.relnamespace 1138 AND pkc.oid 1139 = pka.attrelid 1140 AND pka.attnum 1141 = con.confkey[pos.n] 1142 AND con.confrelid 1143 = pkc.oid 1144 AND fkn.oid 1145 = fkc.relnamespace 1146 AND fkc.oid 1147 = fka.attrelid 1148 AND fka.attnum 1149 = con.conkey[pos.n] 1150 AND con.conrelid 1151 = fkc.oid 1152 AND con.contype = 'f' 1153 AND con.oid 1154 = dep.objid 1155 AND pkic.oid 1156 = dep.refobjid 1157 AND pkic.relkind 1158 = 'i' 1159 AND dep.classid 1160 = 'pg_constraint'::REGCLASS::OID 1161 AND dep.refclassid 1162 = 'pg_class'::REGCLASS::OID 1163 AND fkn.nspname 1164 = 'public' 1165 AND fkc.relname 1166 = 'orders' 1167 ORDER BY pkn.nspname, 1168 pkc.relname, 1169 con.conname, 1170 pos.n 1171 1172 31: 1173 ------------------------------- 1174 SELECT NULL::STRING 1175 AS pktable_cat, 1176 pkn.nspname 1177 AS pktable_schem, 1178 pkc.relname 1179 AS pktable_name, 1180 pka.attname 1181 AS pkcolumn_name, 1182 NULL::STRING 1183 AS fktable_cat, 1184 fkn.nspname 1185 AS fktable_schem, 1186 fkc.relname 1187 AS fktable_name, 1188 fka.attname 1189 AS fkcolumn_name, 1190 pos.n AS key_seq, 1191 CASE con.confupdtype 1192 WHEN 'c' THEN 0 1193 WHEN 'n' THEN 2 1194 WHEN 'd' THEN 4 1195 WHEN 'r' THEN 1 1196 WHEN 'a' THEN 3 1197 ELSE NULL 1198 END AS update_rule, 1199 CASE con.confdeltype 1200 WHEN 'c' THEN 0 1201 WHEN 'n' THEN 2 1202 WHEN 'd' THEN 4 1203 WHEN 'r' THEN 1 1204 WHEN 'a' THEN 3 1205 ELSE NULL 1206 END AS delete_rule, 1207 con.conname 1208 AS fk_name, 1209 pkic.relname 1210 AS pk_name, 1211 CASE 1212 WHEN con.condeferrable 1213 AND con.condeferred 1214 THEN 5 1215 WHEN con.condeferrable 1216 THEN 6 1217 ELSE 7 1218 END AS deferrability 1219 FROM pg_catalog.pg_namespace 1220 AS pkn, 1221 pg_catalog.pg_class 1222 AS pkc, 1223 pg_catalog.pg_attribute 1224 AS pka, 1225 pg_catalog.pg_namespace 1226 AS fkn, 1227 pg_catalog.pg_class 1228 AS fkc, 1229 pg_catalog.pg_attribute 1230 AS fka, 1231 pg_catalog.pg_constraint 1232 AS con, 1233 pg_catalog.generate_series( 1234 1, 1235 32 1236 ) 1237 AS pos (n), 1238 pg_catalog.pg_depend 1239 AS dep, 1240 pg_catalog.pg_class 1241 AS pkic 1242 WHERE pkn.oid 1243 = pkc.relnamespace 1244 AND pkc.oid 1245 = pka.attrelid 1246 AND pka.attnum 1247 = con.confkey[pos.n] 1248 AND con.confrelid 1249 = pkc.oid 1250 AND fkn.oid 1251 = fkc.relnamespace 1252 AND fkc.oid 1253 = fka.attrelid 1254 AND fka.attnum 1255 = con.conkey[pos.n] 1256 AND con.conrelid 1257 = fkc.oid 1258 AND con.contype = 'f' 1259 AND con.oid 1260 = dep.objid 1261 AND pkic.oid 1262 = dep.refobjid 1263 AND pkic.relkind = 'i' 1264 AND dep.classid 1265 = 'pg_constraint'::REGCLASS::OID 1266 AND dep.refclassid 1267 = 'pg_class'::REGCLASS::OID 1268 AND fkn.nspname 1269 = 'public' 1270 AND fkc.relname 1271 = 'orders' 1272 ORDER BY pkn.nspname, 1273 pkc.relname, 1274 con.conname, 1275 pos.n 1276 1277 32: 1278 -------------------------------- 1279 SELECT NULL::STRING 1280 AS pktable_cat, 1281 pkn.nspname 1282 AS pktable_schem, 1283 pkc.relname 1284 AS pktable_name, 1285 pka.attname 1286 AS pkcolumn_name, 1287 NULL::STRING 1288 AS fktable_cat, 1289 fkn.nspname 1290 AS fktable_schem, 1291 fkc.relname 1292 AS fktable_name, 1293 fka.attname 1294 AS fkcolumn_name, 1295 pos.n AS key_seq, 1296 CASE con.confupdtype 1297 WHEN 'c' THEN 0 1298 WHEN 'n' THEN 2 1299 WHEN 'd' THEN 4 1300 WHEN 'r' THEN 1 1301 WHEN 'a' THEN 3 1302 ELSE NULL 1303 END AS update_rule, 1304 CASE con.confdeltype 1305 WHEN 'c' THEN 0 1306 WHEN 'n' THEN 2 1307 WHEN 'd' THEN 4 1308 WHEN 'r' THEN 1 1309 WHEN 'a' THEN 3 1310 ELSE NULL 1311 END AS delete_rule, 1312 con.conname AS fk_name, 1313 pkic.relname 1314 AS pk_name, 1315 CASE 1316 WHEN con.condeferrable 1317 AND con.condeferred 1318 THEN 5 1319 WHEN con.condeferrable 1320 THEN 6 1321 ELSE 7 1322 END AS deferrability 1323 FROM pg_catalog.pg_namespace 1324 AS pkn, 1325 pg_catalog.pg_class 1326 AS pkc, 1327 pg_catalog.pg_attribute 1328 AS pka, 1329 pg_catalog.pg_namespace 1330 AS fkn, 1331 pg_catalog.pg_class 1332 AS fkc, 1333 pg_catalog.pg_attribute 1334 AS fka, 1335 pg_catalog.pg_constraint 1336 AS con, 1337 pg_catalog.generate_series( 1338 1, 1339 32 1340 ) 1341 AS pos (n), 1342 pg_catalog.pg_depend 1343 AS dep, 1344 pg_catalog.pg_class 1345 AS pkic 1346 WHERE pkn.oid 1347 = pkc.relnamespace 1348 AND pkc.oid 1349 = pka.attrelid 1350 AND pka.attnum 1351 = con.confkey[pos.n] 1352 AND con.confrelid 1353 = pkc.oid 1354 AND fkn.oid 1355 = fkc.relnamespace 1356 AND fkc.oid 1357 = fka.attrelid 1358 AND fka.attnum 1359 = con.conkey[pos.n] 1360 AND con.conrelid 1361 = fkc.oid 1362 AND con.contype = 'f' 1363 AND con.oid = dep.objid 1364 AND pkic.oid 1365 = dep.refobjid 1366 AND pkic.relkind = 'i' 1367 AND dep.classid 1368 = 'pg_constraint'::REGCLASS::OID 1369 AND dep.refclassid 1370 = 'pg_class'::REGCLASS::OID 1371 AND fkn.nspname 1372 = 'public' 1373 AND fkc.relname 1374 = 'orders' 1375 ORDER BY pkn.nspname, 1376 pkc.relname, 1377 con.conname, 1378 pos.n 1379 1380 33: 1381 --------------------------------- 1382 SELECT NULL::STRING 1383 AS pktable_cat, 1384 pkn.nspname 1385 AS pktable_schem, 1386 pkc.relname 1387 AS pktable_name, 1388 pka.attname 1389 AS pkcolumn_name, 1390 NULL::STRING 1391 AS fktable_cat, 1392 fkn.nspname 1393 AS fktable_schem, 1394 fkc.relname 1395 AS fktable_name, 1396 fka.attname 1397 AS fkcolumn_name, 1398 pos.n AS key_seq, 1399 CASE con.confupdtype 1400 WHEN 'c' THEN 0 1401 WHEN 'n' THEN 2 1402 WHEN 'd' THEN 4 1403 WHEN 'r' THEN 1 1404 WHEN 'a' THEN 3 1405 ELSE NULL 1406 END AS update_rule, 1407 CASE con.confdeltype 1408 WHEN 'c' THEN 0 1409 WHEN 'n' THEN 2 1410 WHEN 'd' THEN 4 1411 WHEN 'r' THEN 1 1412 WHEN 'a' THEN 3 1413 ELSE NULL 1414 END AS delete_rule, 1415 con.conname AS fk_name, 1416 pkic.relname AS pk_name, 1417 CASE 1418 WHEN con.condeferrable 1419 AND con.condeferred 1420 THEN 5 1421 WHEN con.condeferrable 1422 THEN 6 1423 ELSE 7 1424 END AS deferrability 1425 FROM pg_catalog.pg_namespace 1426 AS pkn, 1427 pg_catalog.pg_class 1428 AS pkc, 1429 pg_catalog.pg_attribute 1430 AS pka, 1431 pg_catalog.pg_namespace 1432 AS fkn, 1433 pg_catalog.pg_class 1434 AS fkc, 1435 pg_catalog.pg_attribute 1436 AS fka, 1437 pg_catalog.pg_constraint 1438 AS con, 1439 pg_catalog.generate_series( 1440 1, 1441 32 1442 ) 1443 AS pos (n), 1444 pg_catalog.pg_depend 1445 AS dep, 1446 pg_catalog.pg_class 1447 AS pkic 1448 WHERE pkn.oid 1449 = pkc.relnamespace 1450 AND pkc.oid 1451 = pka.attrelid 1452 AND pka.attnum 1453 = con.confkey[pos.n] 1454 AND con.confrelid 1455 = pkc.oid 1456 AND fkn.oid 1457 = fkc.relnamespace 1458 AND fkc.oid 1459 = fka.attrelid 1460 AND fka.attnum 1461 = con.conkey[pos.n] 1462 AND con.conrelid 1463 = fkc.oid 1464 AND con.contype = 'f' 1465 AND con.oid = dep.objid 1466 AND pkic.oid 1467 = dep.refobjid 1468 AND pkic.relkind = 'i' 1469 AND dep.classid 1470 = 'pg_constraint'::REGCLASS::OID 1471 AND dep.refclassid 1472 = 'pg_class'::REGCLASS::OID 1473 AND fkn.nspname 1474 = 'public' 1475 AND fkc.relname 1476 = 'orders' 1477 ORDER BY pkn.nspname, 1478 pkc.relname, 1479 con.conname, 1480 pos.n 1481 1482 35: 1483 ----------------------------------- 1484 SELECT NULL::STRING 1485 AS pktable_cat, 1486 pkn.nspname 1487 AS pktable_schem, 1488 pkc.relname 1489 AS pktable_name, 1490 pka.attname 1491 AS pkcolumn_name, 1492 NULL::STRING 1493 AS fktable_cat, 1494 fkn.nspname 1495 AS fktable_schem, 1496 fkc.relname 1497 AS fktable_name, 1498 fka.attname 1499 AS fkcolumn_name, 1500 pos.n AS key_seq, 1501 CASE con.confupdtype 1502 WHEN 'c' THEN 0 1503 WHEN 'n' THEN 2 1504 WHEN 'd' THEN 4 1505 WHEN 'r' THEN 1 1506 WHEN 'a' THEN 3 1507 ELSE NULL 1508 END AS update_rule, 1509 CASE con.confdeltype 1510 WHEN 'c' THEN 0 1511 WHEN 'n' THEN 2 1512 WHEN 'd' THEN 4 1513 WHEN 'r' THEN 1 1514 WHEN 'a' THEN 3 1515 ELSE NULL 1516 END AS delete_rule, 1517 con.conname AS fk_name, 1518 pkic.relname AS pk_name, 1519 CASE 1520 WHEN con.condeferrable 1521 AND con.condeferred 1522 THEN 5 1523 WHEN con.condeferrable 1524 THEN 6 1525 ELSE 7 1526 END AS deferrability 1527 FROM pg_catalog.pg_namespace 1528 AS pkn, 1529 pg_catalog.pg_class 1530 AS pkc, 1531 pg_catalog.pg_attribute 1532 AS pka, 1533 pg_catalog.pg_namespace 1534 AS fkn, 1535 pg_catalog.pg_class 1536 AS fkc, 1537 pg_catalog.pg_attribute 1538 AS fka, 1539 pg_catalog.pg_constraint 1540 AS con, 1541 pg_catalog.generate_series( 1542 1, 1543 32 1544 ) 1545 AS pos (n), 1546 pg_catalog.pg_depend 1547 AS dep, 1548 pg_catalog.pg_class 1549 AS pkic 1550 WHERE pkn.oid = pkc.relnamespace 1551 AND pkc.oid = pka.attrelid 1552 AND pka.attnum 1553 = con.confkey[pos.n] 1554 AND con.confrelid 1555 = pkc.oid 1556 AND fkn.oid 1557 = fkc.relnamespace 1558 AND fkc.oid = fka.attrelid 1559 AND fka.attnum 1560 = con.conkey[pos.n] 1561 AND con.conrelid = fkc.oid 1562 AND con.contype = 'f' 1563 AND con.oid = dep.objid 1564 AND pkic.oid 1565 = dep.refobjid 1566 AND pkic.relkind = 'i' 1567 AND dep.classid 1568 = 'pg_constraint'::REGCLASS::OID 1569 AND dep.refclassid 1570 = 'pg_class'::REGCLASS::OID 1571 AND fkn.nspname = 'public' 1572 AND fkc.relname = 'orders' 1573 ORDER BY pkn.nspname, 1574 pkc.relname, 1575 con.conname, 1576 pos.n 1577 1578 36: 1579 ------------------------------------ 1580 SELECT NULL::STRING 1581 AS pktable_cat, 1582 pkn.nspname 1583 AS pktable_schem, 1584 pkc.relname 1585 AS pktable_name, 1586 pka.attname 1587 AS pkcolumn_name, 1588 NULL::STRING 1589 AS fktable_cat, 1590 fkn.nspname 1591 AS fktable_schem, 1592 fkc.relname 1593 AS fktable_name, 1594 fka.attname 1595 AS fkcolumn_name, 1596 pos.n AS key_seq, 1597 CASE con.confupdtype 1598 WHEN 'c' THEN 0 1599 WHEN 'n' THEN 2 1600 WHEN 'd' THEN 4 1601 WHEN 'r' THEN 1 1602 WHEN 'a' THEN 3 1603 ELSE NULL 1604 END AS update_rule, 1605 CASE con.confdeltype 1606 WHEN 'c' THEN 0 1607 WHEN 'n' THEN 2 1608 WHEN 'd' THEN 4 1609 WHEN 'r' THEN 1 1610 WHEN 'a' THEN 3 1611 ELSE NULL 1612 END AS delete_rule, 1613 con.conname AS fk_name, 1614 pkic.relname AS pk_name, 1615 CASE 1616 WHEN con.condeferrable 1617 AND con.condeferred 1618 THEN 5 1619 WHEN con.condeferrable 1620 THEN 6 1621 ELSE 7 1622 END AS deferrability 1623 FROM pg_catalog.pg_namespace 1624 AS pkn, 1625 pg_catalog.pg_class AS pkc, 1626 pg_catalog.pg_attribute 1627 AS pka, 1628 pg_catalog.pg_namespace 1629 AS fkn, 1630 pg_catalog.pg_class AS fkc, 1631 pg_catalog.pg_attribute 1632 AS fka, 1633 pg_catalog.pg_constraint 1634 AS con, 1635 pg_catalog.generate_series( 1636 1, 1637 32 1638 ) AS pos (n), 1639 pg_catalog.pg_depend 1640 AS dep, 1641 pg_catalog.pg_class AS pkic 1642 WHERE pkn.oid = pkc.relnamespace 1643 AND pkc.oid = pka.attrelid 1644 AND pka.attnum 1645 = con.confkey[pos.n] 1646 AND con.confrelid = pkc.oid 1647 AND fkn.oid 1648 = fkc.relnamespace 1649 AND fkc.oid = fka.attrelid 1650 AND fka.attnum 1651 = con.conkey[pos.n] 1652 AND con.conrelid = fkc.oid 1653 AND con.contype = 'f' 1654 AND con.oid = dep.objid 1655 AND pkic.oid = dep.refobjid 1656 AND pkic.relkind = 'i' 1657 AND dep.classid 1658 = 'pg_constraint'::REGCLASS::OID 1659 AND dep.refclassid 1660 = 'pg_class'::REGCLASS::OID 1661 AND fkn.nspname = 'public' 1662 AND fkc.relname = 'orders' 1663 ORDER BY pkn.nspname, 1664 pkc.relname, 1665 con.conname, 1666 pos.n 1667 1668 37: 1669 ------------------------------------- 1670 SELECT NULL::STRING AS pktable_cat, 1671 pkn.nspname 1672 AS pktable_schem, 1673 pkc.relname AS pktable_name, 1674 pka.attname 1675 AS pkcolumn_name, 1676 NULL::STRING AS fktable_cat, 1677 fkn.nspname 1678 AS fktable_schem, 1679 fkc.relname AS fktable_name, 1680 fka.attname 1681 AS fkcolumn_name, 1682 pos.n AS key_seq, 1683 CASE con.confupdtype 1684 WHEN 'c' THEN 0 1685 WHEN 'n' THEN 2 1686 WHEN 'd' THEN 4 1687 WHEN 'r' THEN 1 1688 WHEN 'a' THEN 3 1689 ELSE NULL 1690 END AS update_rule, 1691 CASE con.confdeltype 1692 WHEN 'c' THEN 0 1693 WHEN 'n' THEN 2 1694 WHEN 'd' THEN 4 1695 WHEN 'r' THEN 1 1696 WHEN 'a' THEN 3 1697 ELSE NULL 1698 END AS delete_rule, 1699 con.conname AS fk_name, 1700 pkic.relname AS pk_name, 1701 CASE 1702 WHEN con.condeferrable 1703 AND con.condeferred 1704 THEN 5 1705 WHEN con.condeferrable 1706 THEN 6 1707 ELSE 7 1708 END AS deferrability 1709 FROM pg_catalog.pg_namespace 1710 AS pkn, 1711 pg_catalog.pg_class AS pkc, 1712 pg_catalog.pg_attribute 1713 AS pka, 1714 pg_catalog.pg_namespace 1715 AS fkn, 1716 pg_catalog.pg_class AS fkc, 1717 pg_catalog.pg_attribute 1718 AS fka, 1719 pg_catalog.pg_constraint 1720 AS con, 1721 pg_catalog.generate_series( 1722 1, 1723 32 1724 ) AS pos (n), 1725 pg_catalog.pg_depend AS dep, 1726 pg_catalog.pg_class AS pkic 1727 WHERE pkn.oid = pkc.relnamespace 1728 AND pkc.oid = pka.attrelid 1729 AND pka.attnum 1730 = con.confkey[pos.n] 1731 AND con.confrelid = pkc.oid 1732 AND fkn.oid 1733 = fkc.relnamespace 1734 AND fkc.oid = fka.attrelid 1735 AND fka.attnum 1736 = con.conkey[pos.n] 1737 AND con.conrelid = fkc.oid 1738 AND con.contype = 'f' 1739 AND con.oid = dep.objid 1740 AND pkic.oid = dep.refobjid 1741 AND pkic.relkind = 'i' 1742 AND dep.classid 1743 = 'pg_constraint'::REGCLASS::OID 1744 AND dep.refclassid 1745 = 'pg_class'::REGCLASS::OID 1746 AND fkn.nspname = 'public' 1747 AND fkc.relname = 'orders' 1748 ORDER BY pkn.nspname, 1749 pkc.relname, 1750 con.conname, 1751 pos.n 1752 1753 38: 1754 -------------------------------------- 1755 SELECT NULL::STRING AS pktable_cat, 1756 pkn.nspname AS pktable_schem, 1757 pkc.relname AS pktable_name, 1758 pka.attname AS pkcolumn_name, 1759 NULL::STRING AS fktable_cat, 1760 fkn.nspname AS fktable_schem, 1761 fkc.relname AS fktable_name, 1762 fka.attname AS fkcolumn_name, 1763 pos.n AS key_seq, 1764 CASE con.confupdtype 1765 WHEN 'c' THEN 0 1766 WHEN 'n' THEN 2 1767 WHEN 'd' THEN 4 1768 WHEN 'r' THEN 1 1769 WHEN 'a' THEN 3 1770 ELSE NULL 1771 END AS update_rule, 1772 CASE con.confdeltype 1773 WHEN 'c' THEN 0 1774 WHEN 'n' THEN 2 1775 WHEN 'd' THEN 4 1776 WHEN 'r' THEN 1 1777 WHEN 'a' THEN 3 1778 ELSE NULL 1779 END AS delete_rule, 1780 con.conname AS fk_name, 1781 pkic.relname AS pk_name, 1782 CASE 1783 WHEN con.condeferrable 1784 AND con.condeferred 1785 THEN 5 1786 WHEN con.condeferrable THEN 6 1787 ELSE 7 1788 END AS deferrability 1789 FROM pg_catalog.pg_namespace 1790 AS pkn, 1791 pg_catalog.pg_class AS pkc, 1792 pg_catalog.pg_attribute 1793 AS pka, 1794 pg_catalog.pg_namespace 1795 AS fkn, 1796 pg_catalog.pg_class AS fkc, 1797 pg_catalog.pg_attribute 1798 AS fka, 1799 pg_catalog.pg_constraint 1800 AS con, 1801 pg_catalog.generate_series( 1802 1, 1803 32 1804 ) AS pos (n), 1805 pg_catalog.pg_depend AS dep, 1806 pg_catalog.pg_class AS pkic 1807 WHERE pkn.oid = pkc.relnamespace 1808 AND pkc.oid = pka.attrelid 1809 AND pka.attnum 1810 = con.confkey[pos.n] 1811 AND con.confrelid = pkc.oid 1812 AND fkn.oid 1813 = fkc.relnamespace 1814 AND fkc.oid = fka.attrelid 1815 AND fka.attnum 1816 = con.conkey[pos.n] 1817 AND con.conrelid = fkc.oid 1818 AND con.contype = 'f' 1819 AND con.oid = dep.objid 1820 AND pkic.oid = dep.refobjid 1821 AND pkic.relkind = 'i' 1822 AND dep.classid 1823 = 'pg_constraint'::REGCLASS::OID 1824 AND dep.refclassid 1825 = 'pg_class'::REGCLASS::OID 1826 AND fkn.nspname = 'public' 1827 AND fkc.relname = 'orders' 1828 ORDER BY pkn.nspname, 1829 pkc.relname, 1830 con.conname, 1831 pos.n 1832 1833 39: 1834 --------------------------------------- 1835 SELECT NULL::STRING AS pktable_cat, 1836 pkn.nspname AS pktable_schem, 1837 pkc.relname AS pktable_name, 1838 pka.attname AS pkcolumn_name, 1839 NULL::STRING AS fktable_cat, 1840 fkn.nspname AS fktable_schem, 1841 fkc.relname AS fktable_name, 1842 fka.attname AS fkcolumn_name, 1843 pos.n AS key_seq, 1844 CASE con.confupdtype 1845 WHEN 'c' THEN 0 1846 WHEN 'n' THEN 2 1847 WHEN 'd' THEN 4 1848 WHEN 'r' THEN 1 1849 WHEN 'a' THEN 3 1850 ELSE NULL 1851 END AS update_rule, 1852 CASE con.confdeltype 1853 WHEN 'c' THEN 0 1854 WHEN 'n' THEN 2 1855 WHEN 'd' THEN 4 1856 WHEN 'r' THEN 1 1857 WHEN 'a' THEN 3 1858 ELSE NULL 1859 END AS delete_rule, 1860 con.conname AS fk_name, 1861 pkic.relname AS pk_name, 1862 CASE 1863 WHEN con.condeferrable 1864 AND con.condeferred 1865 THEN 5 1866 WHEN con.condeferrable THEN 6 1867 ELSE 7 1868 END AS deferrability 1869 FROM pg_catalog.pg_namespace 1870 AS pkn, 1871 pg_catalog.pg_class AS pkc, 1872 pg_catalog.pg_attribute 1873 AS pka, 1874 pg_catalog.pg_namespace 1875 AS fkn, 1876 pg_catalog.pg_class AS fkc, 1877 pg_catalog.pg_attribute 1878 AS fka, 1879 pg_catalog.pg_constraint 1880 AS con, 1881 pg_catalog.generate_series( 1882 1, 1883 32 1884 ) AS pos (n), 1885 pg_catalog.pg_depend AS dep, 1886 pg_catalog.pg_class AS pkic 1887 WHERE pkn.oid = pkc.relnamespace 1888 AND pkc.oid = pka.attrelid 1889 AND pka.attnum 1890 = con.confkey[pos.n] 1891 AND con.confrelid = pkc.oid 1892 AND fkn.oid = fkc.relnamespace 1893 AND fkc.oid = fka.attrelid 1894 AND fka.attnum 1895 = con.conkey[pos.n] 1896 AND con.conrelid = fkc.oid 1897 AND con.contype = 'f' 1898 AND con.oid = dep.objid 1899 AND pkic.oid = dep.refobjid 1900 AND pkic.relkind = 'i' 1901 AND dep.classid 1902 = 'pg_constraint'::REGCLASS::OID 1903 AND dep.refclassid 1904 = 'pg_class'::REGCLASS::OID 1905 AND fkn.nspname = 'public' 1906 AND fkc.relname = 'orders' 1907 ORDER BY pkn.nspname, 1908 pkc.relname, 1909 con.conname, 1910 pos.n 1911 1912 40: 1913 ---------------------------------------- 1914 SELECT NULL::STRING AS pktable_cat, 1915 pkn.nspname AS pktable_schem, 1916 pkc.relname AS pktable_name, 1917 pka.attname AS pkcolumn_name, 1918 NULL::STRING AS fktable_cat, 1919 fkn.nspname AS fktable_schem, 1920 fkc.relname AS fktable_name, 1921 fka.attname AS fkcolumn_name, 1922 pos.n AS key_seq, 1923 CASE con.confupdtype 1924 WHEN 'c' THEN 0 1925 WHEN 'n' THEN 2 1926 WHEN 'd' THEN 4 1927 WHEN 'r' THEN 1 1928 WHEN 'a' THEN 3 1929 ELSE NULL 1930 END AS update_rule, 1931 CASE con.confdeltype 1932 WHEN 'c' THEN 0 1933 WHEN 'n' THEN 2 1934 WHEN 'd' THEN 4 1935 WHEN 'r' THEN 1 1936 WHEN 'a' THEN 3 1937 ELSE NULL 1938 END AS delete_rule, 1939 con.conname AS fk_name, 1940 pkic.relname AS pk_name, 1941 CASE 1942 WHEN con.condeferrable 1943 AND con.condeferred 1944 THEN 5 1945 WHEN con.condeferrable THEN 6 1946 ELSE 7 1947 END AS deferrability 1948 FROM pg_catalog.pg_namespace AS pkn, 1949 pg_catalog.pg_class AS pkc, 1950 pg_catalog.pg_attribute AS pka, 1951 pg_catalog.pg_namespace AS fkn, 1952 pg_catalog.pg_class AS fkc, 1953 pg_catalog.pg_attribute AS fka, 1954 pg_catalog.pg_constraint 1955 AS con, 1956 pg_catalog.generate_series( 1957 1, 1958 32 1959 ) AS pos (n), 1960 pg_catalog.pg_depend AS dep, 1961 pg_catalog.pg_class AS pkic 1962 WHERE pkn.oid = pkc.relnamespace 1963 AND pkc.oid = pka.attrelid 1964 AND pka.attnum 1965 = con.confkey[pos.n] 1966 AND con.confrelid = pkc.oid 1967 AND fkn.oid = fkc.relnamespace 1968 AND fkc.oid = fka.attrelid 1969 AND fka.attnum 1970 = con.conkey[pos.n] 1971 AND con.conrelid = fkc.oid 1972 AND con.contype = 'f' 1973 AND con.oid = dep.objid 1974 AND pkic.oid = dep.refobjid 1975 AND pkic.relkind = 'i' 1976 AND dep.classid 1977 = 'pg_constraint'::REGCLASS::OID 1978 AND dep.refclassid 1979 = 'pg_class'::REGCLASS::OID 1980 AND fkn.nspname = 'public' 1981 AND fkc.relname = 'orders' 1982 ORDER BY pkn.nspname, 1983 pkc.relname, 1984 con.conname, 1985 pos.n 1986 1987 41: 1988 ----------------------------------------- 1989 SELECT NULL::STRING AS pktable_cat, 1990 pkn.nspname AS pktable_schem, 1991 pkc.relname AS pktable_name, 1992 pka.attname AS pkcolumn_name, 1993 NULL::STRING AS fktable_cat, 1994 fkn.nspname AS fktable_schem, 1995 fkc.relname AS fktable_name, 1996 fka.attname AS fkcolumn_name, 1997 pos.n AS key_seq, 1998 CASE con.confupdtype 1999 WHEN 'c' THEN 0 2000 WHEN 'n' THEN 2 2001 WHEN 'd' THEN 4 2002 WHEN 'r' THEN 1 2003 WHEN 'a' THEN 3 2004 ELSE NULL 2005 END AS update_rule, 2006 CASE con.confdeltype 2007 WHEN 'c' THEN 0 2008 WHEN 'n' THEN 2 2009 WHEN 'd' THEN 4 2010 WHEN 'r' THEN 1 2011 WHEN 'a' THEN 3 2012 ELSE NULL 2013 END AS delete_rule, 2014 con.conname AS fk_name, 2015 pkic.relname AS pk_name, 2016 CASE 2017 WHEN con.condeferrable 2018 AND con.condeferred 2019 THEN 5 2020 WHEN con.condeferrable THEN 6 2021 ELSE 7 2022 END AS deferrability 2023 FROM pg_catalog.pg_namespace AS pkn, 2024 pg_catalog.pg_class AS pkc, 2025 pg_catalog.pg_attribute AS pka, 2026 pg_catalog.pg_namespace AS fkn, 2027 pg_catalog.pg_class AS fkc, 2028 pg_catalog.pg_attribute AS fka, 2029 pg_catalog.pg_constraint AS con, 2030 pg_catalog.generate_series( 2031 1, 2032 32 2033 ) AS pos (n), 2034 pg_catalog.pg_depend AS dep, 2035 pg_catalog.pg_class AS pkic 2036 WHERE pkn.oid = pkc.relnamespace 2037 AND pkc.oid = pka.attrelid 2038 AND pka.attnum 2039 = con.confkey[pos.n] 2040 AND con.confrelid = pkc.oid 2041 AND fkn.oid = fkc.relnamespace 2042 AND fkc.oid = fka.attrelid 2043 AND fka.attnum 2044 = con.conkey[pos.n] 2045 AND con.conrelid = fkc.oid 2046 AND con.contype = 'f' 2047 AND con.oid = dep.objid 2048 AND pkic.oid = dep.refobjid 2049 AND pkic.relkind = 'i' 2050 AND dep.classid 2051 = 'pg_constraint'::REGCLASS::OID 2052 AND dep.refclassid 2053 = 'pg_class'::REGCLASS::OID 2054 AND fkn.nspname = 'public' 2055 AND fkc.relname = 'orders' 2056 ORDER BY pkn.nspname, 2057 pkc.relname, 2058 con.conname, 2059 pos.n 2060 2061 43: 2062 ------------------------------------------- 2063 SELECT NULL::STRING AS pktable_cat, 2064 pkn.nspname AS pktable_schem, 2065 pkc.relname AS pktable_name, 2066 pka.attname AS pkcolumn_name, 2067 NULL::STRING AS fktable_cat, 2068 fkn.nspname AS fktable_schem, 2069 fkc.relname AS fktable_name, 2070 fka.attname AS fkcolumn_name, 2071 pos.n AS key_seq, 2072 CASE con.confupdtype 2073 WHEN 'c' THEN 0 2074 WHEN 'n' THEN 2 2075 WHEN 'd' THEN 4 2076 WHEN 'r' THEN 1 2077 WHEN 'a' THEN 3 2078 ELSE NULL 2079 END AS update_rule, 2080 CASE con.confdeltype 2081 WHEN 'c' THEN 0 2082 WHEN 'n' THEN 2 2083 WHEN 'd' THEN 4 2084 WHEN 'r' THEN 1 2085 WHEN 'a' THEN 3 2086 ELSE NULL 2087 END AS delete_rule, 2088 con.conname AS fk_name, 2089 pkic.relname AS pk_name, 2090 CASE 2091 WHEN con.condeferrable 2092 AND con.condeferred 2093 THEN 5 2094 WHEN con.condeferrable THEN 6 2095 ELSE 7 2096 END AS deferrability 2097 FROM pg_catalog.pg_namespace AS pkn, 2098 pg_catalog.pg_class AS pkc, 2099 pg_catalog.pg_attribute AS pka, 2100 pg_catalog.pg_namespace AS fkn, 2101 pg_catalog.pg_class AS fkc, 2102 pg_catalog.pg_attribute AS fka, 2103 pg_catalog.pg_constraint AS con, 2104 pg_catalog.generate_series( 2105 1, 2106 32 2107 ) AS pos (n), 2108 pg_catalog.pg_depend AS dep, 2109 pg_catalog.pg_class AS pkic 2110 WHERE pkn.oid = pkc.relnamespace 2111 AND pkc.oid = pka.attrelid 2112 AND pka.attnum 2113 = con.confkey[pos.n] 2114 AND con.confrelid = pkc.oid 2115 AND fkn.oid = fkc.relnamespace 2116 AND fkc.oid = fka.attrelid 2117 AND fka.attnum = con.conkey[pos.n] 2118 AND con.conrelid = fkc.oid 2119 AND con.contype = 'f' 2120 AND con.oid = dep.objid 2121 AND pkic.oid = dep.refobjid 2122 AND pkic.relkind = 'i' 2123 AND dep.classid 2124 = 'pg_constraint'::REGCLASS::OID 2125 AND dep.refclassid 2126 = 'pg_class'::REGCLASS::OID 2127 AND fkn.nspname = 'public' 2128 AND fkc.relname = 'orders' 2129 ORDER BY pkn.nspname, 2130 pkc.relname, 2131 con.conname, 2132 pos.n 2133 2134 44: 2135 -------------------------------------------- 2136 SELECT NULL::STRING AS pktable_cat, 2137 pkn.nspname AS pktable_schem, 2138 pkc.relname AS pktable_name, 2139 pka.attname AS pkcolumn_name, 2140 NULL::STRING AS fktable_cat, 2141 fkn.nspname AS fktable_schem, 2142 fkc.relname AS fktable_name, 2143 fka.attname AS fkcolumn_name, 2144 pos.n AS key_seq, 2145 CASE con.confupdtype 2146 WHEN 'c' THEN 0 2147 WHEN 'n' THEN 2 2148 WHEN 'd' THEN 4 2149 WHEN 'r' THEN 1 2150 WHEN 'a' THEN 3 2151 ELSE NULL 2152 END AS update_rule, 2153 CASE con.confdeltype 2154 WHEN 'c' THEN 0 2155 WHEN 'n' THEN 2 2156 WHEN 'd' THEN 4 2157 WHEN 'r' THEN 1 2158 WHEN 'a' THEN 3 2159 ELSE NULL 2160 END AS delete_rule, 2161 con.conname AS fk_name, 2162 pkic.relname AS pk_name, 2163 CASE 2164 WHEN con.condeferrable 2165 AND con.condeferred 2166 THEN 5 2167 WHEN con.condeferrable THEN 6 2168 ELSE 7 2169 END AS deferrability 2170 FROM pg_catalog.pg_namespace AS pkn, 2171 pg_catalog.pg_class AS pkc, 2172 pg_catalog.pg_attribute AS pka, 2173 pg_catalog.pg_namespace AS fkn, 2174 pg_catalog.pg_class AS fkc, 2175 pg_catalog.pg_attribute AS fka, 2176 pg_catalog.pg_constraint AS con, 2177 pg_catalog.generate_series( 2178 1, 2179 32 2180 ) AS pos (n), 2181 pg_catalog.pg_depend AS dep, 2182 pg_catalog.pg_class AS pkic 2183 WHERE pkn.oid = pkc.relnamespace 2184 AND pkc.oid = pka.attrelid 2185 AND pka.attnum = con.confkey[pos.n] 2186 AND con.confrelid = pkc.oid 2187 AND fkn.oid = fkc.relnamespace 2188 AND fkc.oid = fka.attrelid 2189 AND fka.attnum = con.conkey[pos.n] 2190 AND con.conrelid = fkc.oid 2191 AND con.contype = 'f' 2192 AND con.oid = dep.objid 2193 AND pkic.oid = dep.refobjid 2194 AND pkic.relkind = 'i' 2195 AND dep.classid 2196 = 'pg_constraint'::REGCLASS::OID 2197 AND dep.refclassid 2198 = 'pg_class'::REGCLASS::OID 2199 AND fkn.nspname = 'public' 2200 AND fkc.relname = 'orders' 2201 ORDER BY pkn.nspname, 2202 pkc.relname, 2203 con.conname, 2204 pos.n 2205 2206 49: 2207 ------------------------------------------------- 2208 SELECT NULL::STRING AS pktable_cat, 2209 pkn.nspname AS pktable_schem, 2210 pkc.relname AS pktable_name, 2211 pka.attname AS pkcolumn_name, 2212 NULL::STRING AS fktable_cat, 2213 fkn.nspname AS fktable_schem, 2214 fkc.relname AS fktable_name, 2215 fka.attname AS fkcolumn_name, 2216 pos.n AS key_seq, 2217 CASE con.confupdtype 2218 WHEN 'c' THEN 0 2219 WHEN 'n' THEN 2 2220 WHEN 'd' THEN 4 2221 WHEN 'r' THEN 1 2222 WHEN 'a' THEN 3 2223 ELSE NULL 2224 END AS update_rule, 2225 CASE con.confdeltype 2226 WHEN 'c' THEN 0 2227 WHEN 'n' THEN 2 2228 WHEN 'd' THEN 4 2229 WHEN 'r' THEN 1 2230 WHEN 'a' THEN 3 2231 ELSE NULL 2232 END AS delete_rule, 2233 con.conname AS fk_name, 2234 pkic.relname AS pk_name, 2235 CASE 2236 WHEN con.condeferrable 2237 AND con.condeferred 2238 THEN 5 2239 WHEN con.condeferrable THEN 6 2240 ELSE 7 2241 END AS deferrability 2242 FROM pg_catalog.pg_namespace AS pkn, 2243 pg_catalog.pg_class AS pkc, 2244 pg_catalog.pg_attribute AS pka, 2245 pg_catalog.pg_namespace AS fkn, 2246 pg_catalog.pg_class AS fkc, 2247 pg_catalog.pg_attribute AS fka, 2248 pg_catalog.pg_constraint AS con, 2249 pg_catalog.generate_series(1, 32) AS pos 2250 (n), 2251 pg_catalog.pg_depend AS dep, 2252 pg_catalog.pg_class AS pkic 2253 WHERE pkn.oid = pkc.relnamespace 2254 AND pkc.oid = pka.attrelid 2255 AND pka.attnum = con.confkey[pos.n] 2256 AND con.confrelid = pkc.oid 2257 AND fkn.oid = fkc.relnamespace 2258 AND fkc.oid = fka.attrelid 2259 AND fka.attnum = con.conkey[pos.n] 2260 AND con.conrelid = fkc.oid 2261 AND con.contype = 'f' 2262 AND con.oid = dep.objid 2263 AND pkic.oid = dep.refobjid 2264 AND pkic.relkind = 'i' 2265 AND dep.classid 2266 = 'pg_constraint'::REGCLASS::OID 2267 AND dep.refclassid 2268 = 'pg_class'::REGCLASS::OID 2269 AND fkn.nspname = 'public' 2270 AND fkc.relname = 'orders' 2271 ORDER BY pkn.nspname, 2272 pkc.relname, 2273 con.conname, 2274 pos.n 2275 2276 51: 2277 --------------------------------------------------- 2278 SELECT NULL::STRING AS pktable_cat, 2279 pkn.nspname AS pktable_schem, 2280 pkc.relname AS pktable_name, 2281 pka.attname AS pkcolumn_name, 2282 NULL::STRING AS fktable_cat, 2283 fkn.nspname AS fktable_schem, 2284 fkc.relname AS fktable_name, 2285 fka.attname AS fkcolumn_name, 2286 pos.n AS key_seq, 2287 CASE con.confupdtype 2288 WHEN 'c' THEN 0 2289 WHEN 'n' THEN 2 2290 WHEN 'd' THEN 4 2291 WHEN 'r' THEN 1 2292 WHEN 'a' THEN 3 2293 ELSE NULL 2294 END AS update_rule, 2295 CASE con.confdeltype 2296 WHEN 'c' THEN 0 2297 WHEN 'n' THEN 2 2298 WHEN 'd' THEN 4 2299 WHEN 'r' THEN 1 2300 WHEN 'a' THEN 3 2301 ELSE NULL 2302 END AS delete_rule, 2303 con.conname AS fk_name, 2304 pkic.relname AS pk_name, 2305 CASE 2306 WHEN con.condeferrable AND con.condeferred 2307 THEN 5 2308 WHEN con.condeferrable THEN 6 2309 ELSE 7 2310 END AS deferrability 2311 FROM 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 ( 2319 n 2320 ), 2321 pg_catalog.pg_depend AS dep, 2322 pg_catalog.pg_class AS pkic 2323 WHERE pkn.oid = pkc.relnamespace 2324 AND pkc.oid = pka.attrelid 2325 AND pka.attnum = con.confkey[pos.n] 2326 AND con.confrelid = pkc.oid 2327 AND fkn.oid = fkc.relnamespace 2328 AND fkc.oid = fka.attrelid 2329 AND fka.attnum = con.conkey[pos.n] 2330 AND con.conrelid = fkc.oid 2331 AND con.contype = 'f' 2332 AND con.oid = dep.objid 2333 AND pkic.oid = dep.refobjid 2334 AND pkic.relkind = 'i' 2335 AND dep.classid 2336 = 'pg_constraint'::REGCLASS::OID 2337 AND dep.refclassid 2338 = 'pg_class'::REGCLASS::OID 2339 AND fkn.nspname = 'public' 2340 AND fkc.relname = 'orders' 2341 ORDER BY pkn.nspname, 2342 pkc.relname, 2343 con.conname, 2344 pos.n 2345 2346 53: 2347 ----------------------------------------------------- 2348 SELECT NULL::STRING AS pktable_cat, 2349 pkn.nspname AS pktable_schem, 2350 pkc.relname AS pktable_name, 2351 pka.attname AS pkcolumn_name, 2352 NULL::STRING AS fktable_cat, 2353 fkn.nspname AS fktable_schem, 2354 fkc.relname AS fktable_name, 2355 fka.attname AS fkcolumn_name, 2356 pos.n AS key_seq, 2357 CASE con.confupdtype 2358 WHEN 'c' THEN 0 2359 WHEN 'n' THEN 2 2360 WHEN 'd' THEN 4 2361 WHEN 'r' THEN 1 2362 WHEN 'a' THEN 3 2363 ELSE NULL 2364 END AS update_rule, 2365 CASE con.confdeltype 2366 WHEN 'c' THEN 0 2367 WHEN 'n' THEN 2 2368 WHEN 'd' THEN 4 2369 WHEN 'r' THEN 1 2370 WHEN 'a' THEN 3 2371 ELSE NULL 2372 END AS delete_rule, 2373 con.conname AS fk_name, 2374 pkic.relname AS pk_name, 2375 CASE 2376 WHEN con.condeferrable AND con.condeferred 2377 THEN 5 2378 WHEN con.condeferrable THEN 6 2379 ELSE 7 2380 END AS deferrability 2381 FROM pg_catalog.pg_namespace AS pkn, 2382 pg_catalog.pg_class AS pkc, 2383 pg_catalog.pg_attribute AS pka, 2384 pg_catalog.pg_namespace AS fkn, 2385 pg_catalog.pg_class AS fkc, 2386 pg_catalog.pg_attribute AS fka, 2387 pg_catalog.pg_constraint AS con, 2388 pg_catalog.generate_series(1, 32) AS pos ( 2389 n 2390 ), 2391 pg_catalog.pg_depend AS dep, 2392 pg_catalog.pg_class AS pkic 2393 WHERE pkn.oid = pkc.relnamespace 2394 AND pkc.oid = pka.attrelid 2395 AND pka.attnum = con.confkey[pos.n] 2396 AND con.confrelid = pkc.oid 2397 AND fkn.oid = fkc.relnamespace 2398 AND fkc.oid = fka.attrelid 2399 AND fka.attnum = con.conkey[pos.n] 2400 AND con.conrelid = fkc.oid 2401 AND con.contype = 'f' 2402 AND con.oid = dep.objid 2403 AND pkic.oid = dep.refobjid 2404 AND pkic.relkind = 'i' 2405 AND dep.classid 2406 = 'pg_constraint'::REGCLASS::OID 2407 AND dep.refclassid 2408 = 'pg_class'::REGCLASS::OID 2409 AND fkn.nspname = 'public' 2410 AND fkc.relname = 'orders' 2411 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2412 2413 54: 2414 ------------------------------------------------------ 2415 SELECT NULL::STRING AS pktable_cat, 2416 pkn.nspname AS pktable_schem, 2417 pkc.relname AS pktable_name, 2418 pka.attname AS pkcolumn_name, 2419 NULL::STRING AS fktable_cat, 2420 fkn.nspname AS fktable_schem, 2421 fkc.relname AS fktable_name, 2422 fka.attname AS fkcolumn_name, 2423 pos.n AS key_seq, 2424 CASE con.confupdtype 2425 WHEN 'c' THEN 0 2426 WHEN 'n' THEN 2 2427 WHEN 'd' THEN 4 2428 WHEN 'r' THEN 1 2429 WHEN 'a' THEN 3 2430 ELSE NULL 2431 END AS update_rule, 2432 CASE con.confdeltype 2433 WHEN 'c' THEN 0 2434 WHEN 'n' THEN 2 2435 WHEN 'd' THEN 4 2436 WHEN 'r' THEN 1 2437 WHEN 'a' THEN 3 2438 ELSE NULL 2439 END AS delete_rule, 2440 con.conname AS fk_name, 2441 pkic.relname AS pk_name, 2442 CASE 2443 WHEN con.condeferrable AND con.condeferred 2444 THEN 5 2445 WHEN con.condeferrable THEN 6 2446 ELSE 7 2447 END AS deferrability 2448 FROM pg_catalog.pg_namespace AS pkn, 2449 pg_catalog.pg_class AS pkc, 2450 pg_catalog.pg_attribute AS pka, 2451 pg_catalog.pg_namespace AS fkn, 2452 pg_catalog.pg_class AS fkc, 2453 pg_catalog.pg_attribute AS fka, 2454 pg_catalog.pg_constraint AS con, 2455 pg_catalog.generate_series(1, 32) AS pos (n), 2456 pg_catalog.pg_depend AS dep, 2457 pg_catalog.pg_class AS pkic 2458 WHERE pkn.oid = pkc.relnamespace 2459 AND pkc.oid = pka.attrelid 2460 AND pka.attnum = con.confkey[pos.n] 2461 AND con.confrelid = pkc.oid 2462 AND fkn.oid = fkc.relnamespace 2463 AND fkc.oid = fka.attrelid 2464 AND fka.attnum = con.conkey[pos.n] 2465 AND con.conrelid = fkc.oid 2466 AND con.contype = 'f' 2467 AND con.oid = dep.objid 2468 AND pkic.oid = dep.refobjid 2469 AND pkic.relkind = 'i' 2470 AND dep.classid 2471 = 'pg_constraint'::REGCLASS::OID 2472 AND dep.refclassid 2473 = 'pg_class'::REGCLASS::OID 2474 AND fkn.nspname = 'public' 2475 AND fkc.relname = 'orders' 2476 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2477 2478 55: 2479 ------------------------------------------------------- 2480 SELECT NULL::STRING AS pktable_cat, 2481 pkn.nspname AS pktable_schem, 2482 pkc.relname AS pktable_name, 2483 pka.attname AS pkcolumn_name, 2484 NULL::STRING AS fktable_cat, 2485 fkn.nspname AS fktable_schem, 2486 fkc.relname AS fktable_name, 2487 fka.attname AS fkcolumn_name, 2488 pos.n AS key_seq, 2489 CASE con.confupdtype 2490 WHEN 'c' THEN 0 2491 WHEN 'n' THEN 2 2492 WHEN 'd' THEN 4 2493 WHEN 'r' THEN 1 2494 WHEN 'a' THEN 3 2495 ELSE NULL 2496 END AS update_rule, 2497 CASE con.confdeltype 2498 WHEN 'c' THEN 0 2499 WHEN 'n' THEN 2 2500 WHEN 'd' THEN 4 2501 WHEN 'r' THEN 1 2502 WHEN 'a' THEN 3 2503 ELSE NULL 2504 END AS delete_rule, 2505 con.conname AS fk_name, 2506 pkic.relname AS pk_name, 2507 CASE 2508 WHEN con.condeferrable AND con.condeferred 2509 THEN 5 2510 WHEN con.condeferrable THEN 6 2511 ELSE 7 2512 END AS deferrability 2513 FROM pg_catalog.pg_namespace AS pkn, 2514 pg_catalog.pg_class AS pkc, 2515 pg_catalog.pg_attribute AS pka, 2516 pg_catalog.pg_namespace AS fkn, 2517 pg_catalog.pg_class AS fkc, 2518 pg_catalog.pg_attribute AS fka, 2519 pg_catalog.pg_constraint AS con, 2520 pg_catalog.generate_series(1, 32) AS pos (n), 2521 pg_catalog.pg_depend AS dep, 2522 pg_catalog.pg_class AS pkic 2523 WHERE pkn.oid = pkc.relnamespace 2524 AND pkc.oid = pka.attrelid 2525 AND pka.attnum = con.confkey[pos.n] 2526 AND con.confrelid = pkc.oid 2527 AND fkn.oid = fkc.relnamespace 2528 AND fkc.oid = fka.attrelid 2529 AND fka.attnum = con.conkey[pos.n] 2530 AND con.conrelid = fkc.oid 2531 AND con.contype = 'f' 2532 AND con.oid = dep.objid 2533 AND pkic.oid = dep.refobjid 2534 AND pkic.relkind = 'i' 2535 AND dep.classid 2536 = 'pg_constraint'::REGCLASS::OID 2537 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2538 AND fkn.nspname = 'public' 2539 AND fkc.relname = 'orders' 2540 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2541 2542 57: 2543 --------------------------------------------------------- 2544 SELECT NULL::STRING AS pktable_cat, 2545 pkn.nspname AS pktable_schem, 2546 pkc.relname AS pktable_name, 2547 pka.attname AS pkcolumn_name, 2548 NULL::STRING AS fktable_cat, 2549 fkn.nspname AS fktable_schem, 2550 fkc.relname AS fktable_name, 2551 fka.attname AS fkcolumn_name, 2552 pos.n AS key_seq, 2553 CASE con.confupdtype 2554 WHEN 'c' THEN 0 2555 WHEN 'n' THEN 2 2556 WHEN 'd' THEN 4 2557 WHEN 'r' THEN 1 2558 WHEN 'a' THEN 3 2559 ELSE NULL 2560 END AS update_rule, 2561 CASE con.confdeltype 2562 WHEN 'c' THEN 0 2563 WHEN 'n' THEN 2 2564 WHEN 'd' THEN 4 2565 WHEN 'r' THEN 1 2566 WHEN 'a' THEN 3 2567 ELSE NULL 2568 END AS delete_rule, 2569 con.conname AS fk_name, 2570 pkic.relname AS pk_name, 2571 CASE 2572 WHEN con.condeferrable AND con.condeferred 2573 THEN 5 2574 WHEN con.condeferrable THEN 6 2575 ELSE 7 2576 END AS deferrability 2577 FROM pg_catalog.pg_namespace AS pkn, 2578 pg_catalog.pg_class AS pkc, 2579 pg_catalog.pg_attribute AS pka, 2580 pg_catalog.pg_namespace AS fkn, 2581 pg_catalog.pg_class AS fkc, 2582 pg_catalog.pg_attribute AS fka, 2583 pg_catalog.pg_constraint AS con, 2584 pg_catalog.generate_series(1, 32) AS pos (n), 2585 pg_catalog.pg_depend AS dep, 2586 pg_catalog.pg_class AS pkic 2587 WHERE pkn.oid = pkc.relnamespace 2588 AND pkc.oid = pka.attrelid 2589 AND pka.attnum = con.confkey[pos.n] 2590 AND con.confrelid = pkc.oid 2591 AND fkn.oid = fkc.relnamespace 2592 AND fkc.oid = fka.attrelid 2593 AND fka.attnum = con.conkey[pos.n] 2594 AND con.conrelid = fkc.oid 2595 AND con.contype = 'f' 2596 AND con.oid = dep.objid 2597 AND pkic.oid = dep.refobjid 2598 AND pkic.relkind = 'i' 2599 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2600 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2601 AND fkn.nspname = 'public' 2602 AND fkc.relname = 'orders' 2603 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2604 2605 58: 2606 ---------------------------------------------------------- 2607 SELECT NULL::STRING AS pktable_cat, 2608 pkn.nspname AS pktable_schem, 2609 pkc.relname AS pktable_name, 2610 pka.attname AS pkcolumn_name, 2611 NULL::STRING AS fktable_cat, 2612 fkn.nspname AS fktable_schem, 2613 fkc.relname AS fktable_name, 2614 fka.attname AS fkcolumn_name, 2615 pos.n AS key_seq, 2616 CASE con.confupdtype 2617 WHEN 'c' THEN 0 2618 WHEN 'n' THEN 2 2619 WHEN 'd' THEN 4 2620 WHEN 'r' THEN 1 2621 WHEN 'a' THEN 3 2622 ELSE NULL 2623 END AS update_rule, 2624 CASE con.confdeltype 2625 WHEN 'c' THEN 0 2626 WHEN 'n' THEN 2 2627 WHEN 'd' THEN 4 2628 WHEN 'r' THEN 1 2629 WHEN 'a' THEN 3 2630 ELSE NULL 2631 END AS delete_rule, 2632 con.conname AS fk_name, 2633 pkic.relname AS pk_name, 2634 CASE 2635 WHEN con.condeferrable AND con.condeferred THEN 5 2636 WHEN con.condeferrable THEN 6 2637 ELSE 7 2638 END AS deferrability 2639 FROM pg_catalog.pg_namespace AS pkn, 2640 pg_catalog.pg_class AS pkc, 2641 pg_catalog.pg_attribute AS pka, 2642 pg_catalog.pg_namespace AS fkn, 2643 pg_catalog.pg_class AS fkc, 2644 pg_catalog.pg_attribute AS fka, 2645 pg_catalog.pg_constraint AS con, 2646 pg_catalog.generate_series(1, 32) AS pos (n), 2647 pg_catalog.pg_depend AS dep, 2648 pg_catalog.pg_class AS pkic 2649 WHERE pkn.oid = pkc.relnamespace 2650 AND pkc.oid = pka.attrelid 2651 AND pka.attnum = con.confkey[pos.n] 2652 AND con.confrelid = pkc.oid 2653 AND fkn.oid = fkc.relnamespace 2654 AND fkc.oid = fka.attrelid 2655 AND fka.attnum = con.conkey[pos.n] 2656 AND con.conrelid = fkc.oid 2657 AND con.contype = 'f' 2658 AND con.oid = dep.objid 2659 AND pkic.oid = dep.refobjid 2660 AND pkic.relkind = 'i' 2661 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2662 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2663 AND fkn.nspname = 'public' 2664 AND fkc.relname = 'orders' 2665 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2666 2667 121: 2668 ------------------------------------------------------------------------------------------------------------------------- 2669 SELECT NULL::STRING AS pktable_cat, 2670 pkn.nspname AS pktable_schem, 2671 pkc.relname AS pktable_name, 2672 pka.attname AS pkcolumn_name, 2673 NULL::STRING AS fktable_cat, 2674 fkn.nspname AS fktable_schem, 2675 fkc.relname AS fktable_name, 2676 fka.attname AS fkcolumn_name, 2677 pos.n AS key_seq, 2678 CASE con.confupdtype 2679 WHEN 'c' THEN 0 2680 WHEN 'n' THEN 2 2681 WHEN 'd' THEN 4 2682 WHEN 'r' THEN 1 2683 WHEN 'a' THEN 3 2684 ELSE NULL 2685 END AS update_rule, 2686 CASE con.confdeltype 2687 WHEN 'c' THEN 0 2688 WHEN 'n' THEN 2 2689 WHEN 'd' THEN 4 2690 WHEN 'r' THEN 1 2691 WHEN 'a' THEN 3 2692 ELSE NULL 2693 END AS delete_rule, 2694 con.conname AS fk_name, 2695 pkic.relname AS pk_name, 2696 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2697 FROM pg_catalog.pg_namespace AS pkn, 2698 pg_catalog.pg_class AS pkc, 2699 pg_catalog.pg_attribute AS pka, 2700 pg_catalog.pg_namespace AS fkn, 2701 pg_catalog.pg_class AS fkc, 2702 pg_catalog.pg_attribute AS fka, 2703 pg_catalog.pg_constraint AS con, 2704 pg_catalog.generate_series(1, 32) AS pos (n), 2705 pg_catalog.pg_depend AS dep, 2706 pg_catalog.pg_class AS pkic 2707 WHERE pkn.oid = pkc.relnamespace 2708 AND pkc.oid = pka.attrelid 2709 AND pka.attnum = con.confkey[pos.n] 2710 AND con.confrelid = pkc.oid 2711 AND fkn.oid = fkc.relnamespace 2712 AND fkc.oid = fka.attrelid 2713 AND fka.attnum = con.conkey[pos.n] 2714 AND con.conrelid = fkc.oid 2715 AND con.contype = 'f' 2716 AND con.oid = dep.objid 2717 AND pkic.oid = dep.refobjid 2718 AND pkic.relkind = 'i' 2719 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2720 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2721 AND fkn.nspname = 'public' 2722 AND fkc.relname = 'orders' 2723 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2724 2725 139: 2726 ------------------------------------------------------------------------------------------------------------------------------------------- 2727 SELECT NULL::STRING AS pktable_cat, 2728 pkn.nspname AS pktable_schem, 2729 pkc.relname AS pktable_name, 2730 pka.attname AS pkcolumn_name, 2731 NULL::STRING AS fktable_cat, 2732 fkn.nspname AS fktable_schem, 2733 fkc.relname AS fktable_name, 2734 fka.attname AS fkcolumn_name, 2735 pos.n AS key_seq, 2736 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, 2737 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, 2738 con.conname AS fk_name, 2739 pkic.relname AS pk_name, 2740 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2741 FROM pg_catalog.pg_namespace AS pkn, 2742 pg_catalog.pg_class AS pkc, 2743 pg_catalog.pg_attribute AS pka, 2744 pg_catalog.pg_namespace AS fkn, 2745 pg_catalog.pg_class AS fkc, 2746 pg_catalog.pg_attribute AS fka, 2747 pg_catalog.pg_constraint AS con, 2748 pg_catalog.generate_series(1, 32) AS pos (n), 2749 pg_catalog.pg_depend AS dep, 2750 pg_catalog.pg_class AS pkic 2751 WHERE pkn.oid = pkc.relnamespace 2752 AND pkc.oid = pka.attrelid 2753 AND pka.attnum = con.confkey[pos.n] 2754 AND con.confrelid = pkc.oid 2755 AND fkn.oid = fkc.relnamespace 2756 AND fkc.oid = fka.attrelid 2757 AND fka.attnum = con.conkey[pos.n] 2758 AND con.conrelid = fkc.oid 2759 AND con.contype = 'f' 2760 AND con.oid = dep.objid 2761 AND pkic.oid = dep.refobjid 2762 AND pkic.relkind = 'i' 2763 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2764 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2765 AND fkn.nspname = 'public' 2766 AND fkc.relname = 'orders' 2767 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2768 2769 328: 2770 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2771 SELECT NULL::STRING AS pktable_cat, 2772 pkn.nspname AS pktable_schem, 2773 pkc.relname AS pktable_name, 2774 pka.attname AS pkcolumn_name, 2775 NULL::STRING AS fktable_cat, 2776 fkn.nspname AS fktable_schem, 2777 fkc.relname AS fktable_name, 2778 fka.attname AS fkcolumn_name, 2779 pos.n AS key_seq, 2780 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, 2781 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, 2782 con.conname AS fk_name, 2783 pkic.relname AS pk_name, 2784 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2785 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 2786 WHERE pkn.oid = pkc.relnamespace 2787 AND pkc.oid = pka.attrelid 2788 AND pka.attnum = con.confkey[pos.n] 2789 AND con.confrelid = pkc.oid 2790 AND fkn.oid = fkc.relnamespace 2791 AND fkc.oid = fka.attrelid 2792 AND fka.attnum = con.conkey[pos.n] 2793 AND con.conrelid = fkc.oid 2794 AND con.contype = 'f' 2795 AND con.oid = dep.objid 2796 AND pkic.oid = dep.refobjid 2797 AND pkic.relkind = 'i' 2798 AND dep.classid = 'pg_constraint'::REGCLASS::OID 2799 AND dep.refclassid = 'pg_class'::REGCLASS::OID 2800 AND fkn.nspname = 'public' 2801 AND fkc.relname = 'orders' 2802 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2803 2804 493: 2805 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2806 SELECT NULL::STRING AS pktable_cat, 2807 pkn.nspname AS pktable_schem, 2808 pkc.relname AS pktable_name, 2809 pka.attname AS pkcolumn_name, 2810 NULL::STRING AS fktable_cat, 2811 fkn.nspname AS fktable_schem, 2812 fkc.relname AS fktable_name, 2813 fka.attname AS fkcolumn_name, 2814 pos.n AS key_seq, 2815 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, 2816 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, 2817 con.conname AS fk_name, 2818 pkic.relname AS pk_name, 2819 CASE WHEN con.condeferrable AND con.condeferred THEN 5 WHEN con.condeferrable THEN 6 ELSE 7 END AS deferrability 2820 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 2821 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' 2822 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2823 2824 686: 2825 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 2826 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 2827 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 2828 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' 2829 ORDER BY pkn.nspname, pkc.relname, con.conname, pos.n 2830 2831 1554: 2832 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ 2833 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 2834 2835