- Notifications
You must be signed in to change notification settings - Fork5
Commit10a3471
committed
Add a RESTART (without parameter) option to ALTER SEQUENCE, allowing a
sequence to be reset to its original starting value. This requires adding theoriginal start value to the set of parameters (columns) of a sequence object,which is a user-visible change with potential compatibility implications;it also forces initdb.Also add hopefully-SQL-compatible RESTART/CONTINUE IDENTITY options toTRUNCATE TABLE. RESTART IDENTITY executes ALTER SEQUENCE RESTART for allsequences "owned by" any of the truncated relations. CONTINUE IDENTITY isa no-op option.Zoltan Boszormenyi1 parent8a2f5d2 commit10a3471
File tree
18 files changed
+513
-106
lines changed- doc/src/sgml/ref
- src
- backend
- catalog
- commands
- nodes
- parser
- bin/pg_dump
- include
- catalog
- commands
- nodes
- test/regress
- expected
- sql
18 files changed
+513
-106
lines changedLines changed: 7 additions & 4 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
26 | 26 |
| |
27 | 27 |
| |
28 | 28 |
| |
29 |
| - | |
| 29 | + | |
30 | 30 |
| |
31 | 31 |
| |
32 | 32 |
| |
| |||
112 | 112 |
| |
113 | 113 |
| |
114 | 114 |
| |
115 |
| - | |
116 |
| - | |
| 115 | + | |
| 116 | + | |
117 | 117 |
| |
118 | 118 |
| |
119 | 119 |
| |
120 | 120 |
| |
| 121 | + | |
| 122 | + | |
| 123 | + | |
121 | 124 |
| |
122 | 125 |
| |
123 | 126 |
| |
|
Lines changed: 52 additions & 8 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1 | 1 |
| |
2 |
| - | |
| 2 | + | |
3 | 3 |
| |
4 | 4 |
| |
5 | 5 |
| |
| |||
20 | 20 |
| |
21 | 21 |
| |
22 | 22 |
| |
23 |
| - | |
| 23 | + | |
| 24 | + | |
24 | 25 |
| |
25 | 26 |
| |
26 | 27 |
| |
| |||
50 | 51 |
| |
51 | 52 |
| |
52 | 53 |
| |
| 54 | + | |
| 55 | + | |
| 56 | + | |
| 57 | + | |
| 58 | + | |
| 59 | + | |
| 60 | + | |
| 61 | + | |
| 62 | + | |
| 63 | + | |
| 64 | + | |
| 65 | + | |
| 66 | + | |
| 67 | + | |
| 68 | + | |
| 69 | + | |
| 70 | + | |
| 71 | + | |
| 72 | + | |
53 | 73 |
| |
54 | 74 |
| |
55 | 75 |
| |
| |||
66 | 86 |
| |
67 | 87 |
| |
68 | 88 |
| |
69 |
| - | |
| 89 | + | |
70 | 90 |
| |
71 | 91 |
| |
72 | 92 |
| |
| |||
119 | 139 |
| |
120 | 140 |
| |
121 | 141 |
| |
| 142 | + | |
| 143 | + | |
| 144 | + | |
| 145 | + | |
| 146 | + | |
| 147 | + | |
| 148 | + | |
122 | 149 |
| |
| 150 | + | |
123 | 151 |
| |
124 |
| - | |
125 |
| - | |
126 |
| - | |
| 152 | + | |
| 153 | + | |
| 154 | + | |
| 155 | + | |
| 156 | + | |
| 157 | + | |
| 158 | + | |
127 | 159 |
| |
128 | 160 |
| |
129 | 161 |
| |
| |||
132 | 164 |
| |
133 | 165 |
| |
134 | 166 |
| |
135 |
| - | |
| 167 | + | |
| 168 | + | |
136 | 169 |
| |
137 | 170 |
| |
138 | 171 |
| |
139 | 172 |
| |
140 | 173 |
| |
141 | 174 |
| |
| 175 | + | |
| 176 | + | |
| 177 | + | |
| 178 | + | |
| 179 | + | |
| 180 | + | |
| 181 | + | |
| 182 | + | |
142 | 183 |
| |
143 | 184 |
| |
144 | 185 |
| |
| |||
154 | 195 |
| |
155 | 196 |
| |
156 | 197 |
| |
157 |
| - | |
| 198 | + | |
| 199 | + | |
| 200 | + | |
| 201 | + | |
158 | 202 |
| |
159 | 203 |
| |
160 | 204 |
|
Lines changed: 53 additions & 1 deletion
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
8 | 8 |
| |
9 | 9 |
| |
10 | 10 |
| |
11 |
| - | |
| 11 | + | |
12 | 12 |
| |
13 | 13 |
| |
14 | 14 |
| |
| |||
418 | 418 |
| |
419 | 419 |
| |
420 | 420 |
| |
| 421 | + | |
| 422 | + | |
| 423 | + | |
| 424 | + | |
| 425 | + | |
| 426 | + | |
| 427 | + | |
| 428 | + | |
| 429 | + | |
| 430 | + | |
| 431 | + | |
| 432 | + | |
| 433 | + | |
| 434 | + | |
| 435 | + | |
| 436 | + | |
| 437 | + | |
| 438 | + | |
| 439 | + | |
| 440 | + | |
| 441 | + | |
| 442 | + | |
| 443 | + | |
| 444 | + | |
| 445 | + | |
| 446 | + | |
| 447 | + | |
| 448 | + | |
| 449 | + | |
| 450 | + | |
| 451 | + | |
| 452 | + | |
| 453 | + | |
| 454 | + | |
| 455 | + | |
| 456 | + | |
| 457 | + | |
| 458 | + | |
| 459 | + | |
| 460 | + | |
| 461 | + | |
| 462 | + | |
| 463 | + | |
| 464 | + | |
| 465 | + | |
| 466 | + | |
| 467 | + | |
| 468 | + | |
| 469 | + | |
| 470 | + | |
| 471 | + | |
| 472 | + | |
421 | 473 |
| |
422 | 474 |
| |
423 | 475 |
| |
|
0 commit comments
Comments
(0)