forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitca87c41
committed
Add support for NOT ENFORCED in CHECK constraints
This adds support for the NOT ENFORCED/ENFORCED flag for constraints,with support for check constraints.The plan is to eventually support this for foreign key constraints,where it is typically more useful.Note that CHECK constraints do not currently support ALTER operations,so changing the enforceability of an existing constraint isn'tpossible without dropping and recreating it. This could be addedlater.Author: Amul Sul <amul.sul@enterprisedb.com>Reviewed-by: Peter Eisentraut <peter@eisentraut.org>Reviewed-by: jian he <jian.universality@gmail.com>Tested-by: Triveni N <triveni.n@enterprisedb.com>Discussion:https://www.postgresql.org/message-id/flat/CAAJ_b962c5AcYW9KUt_R_ER5qs3fUGbe4az-SP-vuwPS-w-AGA@mail.gmail.com1 parent72ceb21 commitca87c41
File tree
37 files changed
+599
-70
lines changed- doc/src/sgml
- ref
- src
- backend
- access/common
- catalog
- commands
- executor
- nodes
- optimizer/util
- parser
- utils
- adt
- cache
- include
- access
- catalog
- nodes
- parser
- test/regress
- expected
- sql
37 files changed
+599
-70
lines changedLines changed: 10 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2591 | 2591 |
| |
2592 | 2592 |
| |
2593 | 2593 |
| |
| 2594 | + | |
| 2595 | + | |
| 2596 | + | |
| 2597 | + | |
| 2598 | + | |
| 2599 | + | |
| 2600 | + | |
| 2601 | + | |
| 2602 | + | |
| 2603 | + | |
2594 | 2604 |
| |
2595 | 2605 |
| |
2596 | 2606 |
| |
|
Lines changed: 1 addition & 3 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
6896 | 6896 |
| |
6897 | 6897 |
| |
6898 | 6898 |
| |
6899 |
| - | |
6900 |
| - | |
6901 |
| - | |
| 6899 | + | |
6902 | 6900 |
| |
6903 | 6901 |
| |
6904 | 6902 |
| |
|
Lines changed: 7 additions & 5 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
108 | 108 |
| |
109 | 109 |
| |
110 | 110 |
| |
111 |
| - | |
| 111 | + | |
112 | 112 |
| |
113 | 113 |
| |
114 | 114 |
| |
| |||
120 | 120 |
| |
121 | 121 |
| |
122 | 122 |
| |
123 |
| - | |
| 123 | + | |
124 | 124 |
| |
125 | 125 |
| |
126 | 126 |
| |
| |||
1423 | 1423 |
| |
1424 | 1424 |
| |
1425 | 1425 |
| |
1426 |
| - | |
1427 |
| - | |
1428 |
| - | |
| 1426 | + | |
| 1427 | + | |
| 1428 | + | |
| 1429 | + | |
| 1430 | + | |
1429 | 1431 |
| |
1430 | 1432 |
| |
1431 | 1433 |
| |
|
Lines changed: 4 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
48 | 48 |
| |
49 | 49 |
| |
50 | 50 |
| |
| 51 | + | |
51 | 52 |
| |
52 | 53 |
| |
53 | 54 |
| |
54 | 55 |
| |
55 |
| - | |
56 |
| - | |
| 56 | + | |
| 57 | + | |
| 58 | + | |
57 | 59 |
| |
58 | 60 |
| |
59 | 61 |
| |
|
Lines changed: 32 additions & 2 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
71 | 71 |
| |
72 | 72 |
| |
73 | 73 |
| |
74 |
| - | |
| 74 | + | |
75 | 75 |
| |
76 | 76 |
| |
77 | 77 |
| |
| |||
84 | 84 |
| |
85 | 85 |
| |
86 | 86 |
| |
87 |
| - | |
| 87 | + | |
88 | 88 |
| |
89 | 89 |
| |
90 | 90 |
| |
| |||
1377 | 1377 |
| |
1378 | 1378 |
| |
1379 | 1379 |
| |
| 1380 | + | |
| 1381 | + | |
| 1382 | + | |
| 1383 | + | |
| 1384 | + | |
| 1385 | + | |
| 1386 | + | |
| 1387 | + | |
| 1388 | + | |
| 1389 | + | |
| 1390 | + | |
| 1391 | + | |
| 1392 | + | |
| 1393 | + | |
| 1394 | + | |
| 1395 | + | |
| 1396 | + | |
| 1397 | + | |
| 1398 | + | |
| 1399 | + | |
| 1400 | + | |
| 1401 | + | |
| 1402 | + | |
| 1403 | + | |
| 1404 | + | |
| 1405 | + | |
| 1406 | + | |
| 1407 | + | |
| 1408 | + | |
| 1409 | + | |
1380 | 1410 |
| |
1381 | 1411 |
| |
1382 | 1412 |
| |
|
Lines changed: 2 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
376 | 376 |
| |
377 | 377 |
| |
378 | 378 |
| |
| 379 | + | |
379 | 380 |
| |
380 | 381 |
| |
381 | 382 |
| |
| |||
692 | 693 |
| |
693 | 694 |
| |
694 | 695 |
| |
| 696 | + | |
695 | 697 |
| |
696 | 698 |
| |
697 | 699 |
| |
|
Lines changed: 45 additions & 10 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
102 | 102 |
| |
103 | 103 |
| |
104 | 104 |
| |
105 |
| - | |
106 |
| - | |
| 105 | + | |
| 106 | + | |
107 | 107 |
| |
108 | 108 |
| |
109 | 109 |
| |
110 | 110 |
| |
| 111 | + | |
111 | 112 |
| |
112 | 113 |
| |
113 | 114 |
| |
| |||
2066 | 2067 |
| |
2067 | 2068 |
| |
2068 | 2069 |
| |
2069 |
| - | |
2070 |
| - | |
| 2070 | + | |
| 2071 | + | |
2071 | 2072 |
| |
2072 | 2073 |
| |
2073 | 2074 |
| |
| |||
2132 | 2133 |
| |
2133 | 2134 |
| |
2134 | 2135 |
| |
| 2136 | + | |
2135 | 2137 |
| |
2136 | 2138 |
| |
2137 | 2139 |
| |
| |||
2185 | 2187 |
| |
2186 | 2188 |
| |
2187 | 2189 |
| |
| 2190 | + | |
2188 | 2191 |
| |
2189 | 2192 |
| |
2190 | 2193 |
| |
| |||
2254 | 2257 |
| |
2255 | 2258 |
| |
2256 | 2259 |
| |
2257 |
| - | |
2258 |
| - | |
2259 |
| - | |
| 2260 | + | |
| 2261 | + | |
| 2262 | + | |
2260 | 2263 |
| |
2261 | 2264 |
| |
2262 | 2265 |
| |
| |||
2390 | 2393 |
| |
2391 | 2394 |
| |
2392 | 2395 |
| |
| 2396 | + | |
2393 | 2397 |
| |
2394 | 2398 |
| |
2395 | 2399 |
| |
| |||
2461 | 2465 |
| |
2462 | 2466 |
| |
2463 | 2467 |
| |
| 2468 | + | |
2464 | 2469 |
| |
2465 | 2470 |
| |
2466 | 2471 |
| |
| |||
2509 | 2514 |
| |
2510 | 2515 |
| |
2511 | 2516 |
| |
2512 |
| - | |
2513 |
| - | |
| 2517 | + | |
| 2518 | + | |
| 2519 | + | |
| 2520 | + | |
2514 | 2521 |
| |
2515 | 2522 |
| |
2516 | 2523 |
| |
| |||
2520 | 2527 |
| |
2521 | 2528 |
| |
2522 | 2529 |
| |
| 2530 | + | |
2523 | 2531 |
| |
2524 | 2532 |
| |
2525 | 2533 |
| |
| |||
2590 | 2598 |
| |
2591 | 2599 |
| |
2592 | 2600 |
| |
| 2601 | + | |
2593 | 2602 |
| |
2594 | 2603 |
| |
2595 | 2604 |
| |
| |||
2624 | 2633 |
| |
2625 | 2634 |
| |
2626 | 2635 |
| |
| 2636 | + | |
2627 | 2637 |
| |
2628 | 2638 |
| |
2629 | 2639 |
| |
| |||
2714 | 2724 |
| |
2715 | 2725 |
| |
2716 | 2726 |
| |
2717 |
| - | |
| 2727 | + | |
2718 | 2728 |
| |
2719 | 2729 |
| |
2720 | 2730 |
| |
2721 | 2731 |
| |
2722 | 2732 |
| |
| 2733 | + | |
| 2734 | + | |
| 2735 | + | |
| 2736 | + | |
| 2737 | + | |
| 2738 | + | |
| 2739 | + | |
| 2740 | + | |
| 2741 | + | |
| 2742 | + | |
| 2743 | + | |
| 2744 | + | |
2723 | 2745 |
| |
2724 | 2746 |
| |
2725 | 2747 |
| |
| |||
2755 | 2777 |
| |
2756 | 2778 |
| |
2757 | 2779 |
| |
| 2780 | + | |
| 2781 | + | |
| 2782 | + | |
| 2783 | + | |
| 2784 | + | |
| 2785 | + | |
| 2786 | + | |
| 2787 | + | |
| 2788 | + | |
| 2789 | + | |
| 2790 | + | |
| 2791 | + | |
| 2792 | + | |
2758 | 2793 |
| |
2759 | 2794 |
| |
2760 | 2795 |
| |
|
Lines changed: 1 addition & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1958 | 1958 |
| |
1959 | 1959 |
| |
1960 | 1960 |
| |
| 1961 | + | |
1961 | 1962 |
| |
1962 | 1963 |
| |
1963 | 1964 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1844 | 1844 |
| |
1845 | 1845 |
| |
1846 | 1846 |
| |
1847 |
| - | |
| 1847 | + | |
1848 | 1848 |
| |
1849 | 1849 |
| |
1850 | 1850 |
| |
|
Lines changed: 9 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
53 | 53 |
| |
54 | 54 |
| |
55 | 55 |
| |
| 56 | + | |
56 | 57 |
| |
57 | 58 |
| |
58 | 59 |
| |
| |||
99 | 100 |
| |
100 | 101 |
| |
101 | 102 |
| |
| 103 | + | |
| 104 | + | |
| 105 | + | |
| 106 | + | |
| 107 | + | |
102 | 108 |
| |
103 | 109 |
| |
104 | 110 |
| |
| |||
182 | 188 |
| |
183 | 189 |
| |
184 | 190 |
| |
| 191 | + | |
185 | 192 |
| |
186 | 193 |
| |
187 | 194 |
| |
| |||
822 | 829 |
| |
823 | 830 |
| |
824 | 831 |
| |
| 832 | + | |
825 | 833 |
| |
826 | 834 |
| |
827 | 835 |
| |
| |||
841 | 849 |
| |
842 | 850 |
| |
843 | 851 |
| |
| 852 | + | |
844 | 853 |
| |
845 | 854 |
| |
846 | 855 |
| |
|
Lines changed: 1 addition & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
281 | 281 |
| |
282 | 282 |
| |
283 | 283 |
| |
284 |
| - | |
| 284 | + | |
285 | 285 |
| |
286 | 286 |
| |
287 | 287 |
| |
|
0 commit comments
Comments
(0)