forked frompostgres/postgres
- Notifications
You must be signed in to change notification settings - Fork6
Commitadd5cf2
committed
Preserve opclass parameters across REINDEX CONCURRENTLY
The opclass parameter Datums from the old index are fetched in the sameway as for predicates and expressions, by grabbing them directly fromthe system catalogs. They are then copied into the new IndexInfo thatwill be used for the creation of the new copy.This caused the new index to be rebuilt with default parameters ratherthan the ones pre-defined by a user. The only way to get back a newindex with correct opclass parameters would be to recreate a new indexfrom scratch.The issue has been introduced by911e702.Author: Michael PaquierReviewed-by: Zhihong YuDiscussion:https://postgr.es/m/YX0CG/QpLXcPr8HJ@paquier.xyzBackpatch-through: 131 parenta667b06 commitadd5cf2
File tree
3 files changed
+38
-0
lines changed- src
- backend/catalog
- test/regress
- expected
- sql
3 files changed
+38
-0
lines changedLines changed: 10 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
73 | 73 |
| |
74 | 74 |
| |
75 | 75 |
| |
| 76 | + | |
76 | 77 |
| |
77 | 78 |
| |
78 | 79 |
| |
| |||
1365 | 1366 |
| |
1366 | 1367 |
| |
1367 | 1368 |
| |
| 1369 | + | |
| 1370 | + | |
| 1371 | + | |
| 1372 | + | |
| 1373 | + | |
| 1374 | + | |
| 1375 | + | |
| 1376 | + | |
| 1377 | + | |
1368 | 1378 |
| |
1369 | 1379 |
| |
1370 | 1380 |
| |
|
Lines changed: 19 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
2176 | 2176 |
| |
2177 | 2177 |
| |
2178 | 2178 |
| |
| 2179 | + | |
| 2180 | + | |
| 2181 | + | |
| 2182 | + | |
| 2183 | + | |
| 2184 | + | |
| 2185 | + | |
| 2186 | + | |
| 2187 | + | |
| 2188 | + | |
| 2189 | + | |
| 2190 | + | |
| 2191 | + | |
| 2192 | + | |
| 2193 | + | |
| 2194 | + | |
| 2195 | + | |
| 2196 | + | |
| 2197 | + | |
2179 | 2198 |
| |
2180 | 2199 |
| |
2181 | 2200 |
| |
|
Lines changed: 9 additions & 0 deletions
Original file line number | Diff line number | Diff line change | |
---|---|---|---|
| |||
888 | 888 |
| |
889 | 889 |
| |
890 | 890 |
| |
| 891 | + | |
| 892 | + | |
| 893 | + | |
| 894 | + | |
| 895 | + | |
| 896 | + | |
| 897 | + | |
| 898 | + | |
| 899 | + | |
891 | 900 |
| |
892 | 901 |
| |
893 | 902 |
| |
|
0 commit comments
Comments
(0)