forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitbfec14d
committed
Fix ALTER TABLE .. ADD COLUMN with complex inheritance trees
This command, when used to add a column on a parent table with a complexinheritance tree, tried to update multiple times the same tuple inpg_attribute for a child table when incrementing attinhcount, causingfailures with "tuple already updated by self" because of a missingCommandCounterIncrement() between two updates.This exists for a rather long time, so backpatch all the way down.Reported-by: Alexander LakhinAuthor: Tender WangReviewed-by: Richard GuoDiscussion:https://postgr.es/m/18297-b04cd83a55b51e35@postgresql.orgBackpatch-through: 121 parentdc9d424 commitbfec14d
File tree
3 files changed
+30
-0
lines changed- src
- backend/commands
- test/regress
- expected
- sql
3 files changed
+30
-0
lines changedLines changed: 4 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
6291 | 6291 |
| |
6292 | 6292 |
| |
6293 | 6293 |
| |
| 6294 | + | |
| 6295 | + | |
| 6296 | + | |
| 6297 | + | |
6294 | 6298 |
| |
6295 | 6299 |
| |
6296 | 6300 |
| |
|
Lines changed: 17 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
1063 | 1063 |
| |
1064 | 1064 |
| |
1065 | 1065 |
| |
| 1066 | + | |
| 1067 | + | |
| 1068 | + | |
| 1069 | + | |
| 1070 | + | |
| 1071 | + | |
| 1072 | + | |
| 1073 | + | |
| 1074 | + | |
| 1075 | + | |
| 1076 | + | |
| 1077 | + | |
| 1078 | + | |
| 1079 | + | |
| 1080 | + | |
| 1081 | + | |
| 1082 | + | |
1066 | 1083 |
| |
1067 | 1084 |
| |
1068 | 1085 |
| |
|
Lines changed: 9 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
353 | 353 |
| |
354 | 354 |
| |
355 | 355 |
| |
| 356 | + | |
| 357 | + | |
| 358 | + | |
| 359 | + | |
| 360 | + | |
| 361 | + | |
| 362 | + | |
| 363 | + | |
| 364 | + | |
356 | 365 |
| |
357 | 366 |
| |
358 | 367 |
| |
|
0 commit comments
Comments
(0)