pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Ignore invalid indexes when enforcing index rules in ALTER TABLE

2023-06-28 Thread Michael Paquier
Ignore invalid indexes when enforcing index rules in ALTER TABLE ATTACH PARTITION A portion of ALTER TABLE .. ATTACH PARTITION is to ensure that the partition being attached to the partitioned table has a correct set of indexes, so as there is a consistent index mapping between the partitioned ta

pgsql: Add timeline ID to file names generated with pg_waldump --save-f

2023-06-28 Thread Michael Paquier
Add timeline ID to file names generated with pg_waldump --save-fullpage Not including the timeline IDs to the file names generated by pg_waldump for the individual blocks saved could cause some of these files to be overwritten when scanning segments across multiple timelines. Having this informat

pgsql: Doc: minor wording adjustments in transaction isolation discussi

2023-06-28 Thread Tom Lane
Doc: minor wording adjustments in transaction isolation discussion. Re-word for more clarity, per gripe from Anton Sidyakin. Discussion: https://postgr.es/m/168745911769.2239590.6062411529242609...@wrigleys.postgresql.org Branch -- master Details --- https://git.postgresql.org/pg/commi

pgsql: Reword error messages for consistency

2023-06-28 Thread Peter Eisentraut
Reword error messages for consistency Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/046c8c5c8fe26fbce3ba773d49c81e6bbdf73db1 Modified Files -- src/backend/replication/logical/applyparallelworker.c | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-

pgsql: pg_stat_statements: Fix incorrect comment with entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix incorrect comment with entry resets Oversight in 6b4d23f. Author: Japin Li, Richard Guo Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through: 14 Branch -- REL_14_STABLE Details --- https:

pgsql: pg_stat_statements: Fix incorrect comment with entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix incorrect comment with entry resets Oversight in 6b4d23f. Author: Japin Li, Richard Guo Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through: 14 Branch -- REL_15_STABLE Details --- https:

pgsql: pg_stat_statements: Fix incorrect comment with entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix incorrect comment with entry resets Oversight in 6b4d23f. Author: Japin Li, Richard Guo Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through: 14 Branch -- master Details --- https://git.p

pgsql: pg_stat_statements: Fix second comment related to entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix second comment related to entry resets This should have been part of dc73db6, but it got lost in the mix. Oversight in 6b4d23f. Author: Japin Li Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through

pgsql: pg_stat_statements: Fix second comment related to entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix second comment related to entry resets This should have been part of dc73db6, but it got lost in the mix. Oversight in 6b4d23f. Author: Japin Li Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through

pgsql: pg_stat_statements: Fix second comment related to entry resets

2023-06-28 Thread Michael Paquier
pg_stat_statements: Fix second comment related to entry resets This should have been part of dc73db6, but it got lost in the mix. Oversight in 6b4d23f. Author: Japin Li Discussion: https://postgr.es/m/meyp282mb1669fc91c764e277821936d3b6...@meyp282mb1669.ausp282.prod.outlook.com Backpatch-through

pgsql: Fix psql \?'s entries for \dp and \z.

2023-06-28 Thread Nathan Bossart
Fix psql \?'s entries for \dp and \z. d913928c9c added support for the "S" modifier to psql's \dp and \z meta-commands, but it missed updating the corresponding entries in \?'s output. Author: Noriyoshi Shinoda Discussion: https://postgr.es/m/DM4PR84MB17342A51B3A1556CFBC7A4B2EE25A%40DM4PR84MB173