pgsql: Disable use of archiving in 009_twophase.pl

2023-06-21 Thread Michael Paquier
Disable use of archiving in 009_twophase.pl This partially reverts 68cb5af, as using archiving to enforce the rename of the last partial segment of the old timeline at promotion to use .partial as suffix is impacting the tests when it does switchovers. As showed by the logs gathered by the CI in t

pgsql: Disable use of archiving in 009_twophase.pl

2023-06-21 Thread Michael Paquier
Disable use of archiving in 009_twophase.pl This partially reverts 68cb5af, as using archiving to enforce the rename of the last partial segment of the old timeline at promotion to use .partial as suffix is impacting the tests when it does switchovers. As showed by the logs gathered by the CI in t

pgsql: Disable use of archiving in 009_twophase.pl

2023-06-21 Thread Michael Paquier
Disable use of archiving in 009_twophase.pl This partially reverts 68cb5af, as using archiving to enforce the rename of the last partial segment of the old timeline at promotion to use .partial as suffix is impacting the tests when it does switchovers. As showed by the logs gathered by the CI in t

pgsql: Disable use of archiving in 009_twophase.pl

2023-06-21 Thread Michael Paquier
Disable use of archiving in 009_twophase.pl This partially reverts 68cb5af, as using archiving to enforce the rename of the last partial segment of the old timeline at promotion to use .partial as suffix is impacting the tests when it does switchovers. As showed by the logs gathered by the CI in t

pgsql: Allow and require passing files on command line of pgperltidy

2023-06-21 Thread Peter Eisentraut
Allow and require passing files on command line of pgperltidy pgperltidy as well as pgperlcritic and pgperlsyncheck now allow passing files and directories on the command line, like pgindent does. (Previously, they would always operate on the whole tree.) Also, for consistency with pgindent's new

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: Avoid Assert failure when processing empty statement in aborted

2023-06-21 Thread Tom Lane
Avoid Assert failure when processing empty statement in aborted xact. exec_parse_message() wants to create a cached plan in all cases, including for empty input. The empty-input path does not have a test for being in an aborted transaction, making it possible that plancache.c will fail due to try

pgsql: initdb: change default --locale-provider back to libc.

2023-06-21 Thread Jeff Davis
initdb: change default --locale-provider back to libc. Reverts 27b62377b4. Discussion: https://postgr.es/m/[email protected] Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.postgresql.org

pgsql: ICU: do not convert locale 'C' to 'en-US-u-va-posix'.

2023-06-21 Thread Jeff Davis
ICU: do not convert locale 'C' to 'en-US-u-va-posix'. Older versions of ICU canonicalize "C" to "en-US-u-va-posix"; but starting in ICU version 64, the "C" locale is considered obsolete. Postgres commit ea1db8ae70 introduced code to always canonicalize "C" to "en-US-u-va-posix" for consistency and

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/10fa5c425b5854bdde5a0

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/05ffc1fadbe0ce7762b209061634

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/e966b3d12105d23c6933d

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/5f5c38bdba6de81e43196

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/43b28fc39f2224da7f68b

pgsql: doc: update PG history as over "three decades"

2023-06-21 Thread Bruce Momjian
doc: update PG history as over "three decades" Reported-by: Pierre Discussion: https://postgr.es/m/[email protected] Backpatch-through: 11 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/9b4c44fef81918393fd2e

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: nbtree VACUUM: cope with topparent inconsistencies.

2023-06-21 Thread Peter Geoghegan
nbtree VACUUM: cope with topparent inconsistencies. Avoid "right sibling %u of block %u is not next child" errors when vacuuming a corrupt nbtree index. Just LOG the issue and press on. That way VACUUM will have a decent chance of finishing off all required processing for the index (and for the t

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht

pgsql: Doc: mention that extended stats aren't used for joins

2023-06-21 Thread David Rowley
Doc: mention that extended stats aren't used for joins Statistics defined by the CREATE STATISTICS command are only used to assist with the selectivity estimations of base relations, never for joins. Here we mention this fact in the notes section of the CREATE STATISTICS command. Discussion: ht