pgsql: Add option force_initdb to PostgreSQL::Test::Cluster:init()

2024-02-20 Thread Michael Paquier
Add option force_initdb to PostgreSQL::Test::Cluster:init() This option is useful to bypass the default behavior of init() which would create the data folder of a new cluster by copying it from a template previously initdb'd, if any. Copying the data folder is much cheaper than running initdb,

pgsql: Remove extra check_stack_depth() from dropconstraint_internal()

2024-02-20 Thread Alexander Korotkov
Remove extra check_stack_depth() from dropconstraint_internal() The second check was added by d57b7cc33 without taking into account there is already a check since b0f7dd915. Reported-by: Ashutosh Bapat, Alexander Lakhin Discussion:

pgsql: Doc: improve explanation of type interval, especially extract().

2024-02-20 Thread Tom Lane
Doc: improve explanation of type interval, especially extract(). The explanation of interval's behavior in datatype.sgml wasn't wrong exactly, but it was unclear, partly because it buried the lede about there being three internal fields. Rearrange and wordsmith for more clarity. The discussion

pgsql: Doc: improve explanation of type interval, especially extract().

2024-02-20 Thread Tom Lane
Doc: improve explanation of type interval, especially extract(). The explanation of interval's behavior in datatype.sgml wasn't wrong exactly, but it was unclear, partly because it buried the lede about there being three internal fields. Rearrange and wordsmith for more clarity. The discussion

pgsql: Doc: improve explanation of type interval, especially extract().

2024-02-20 Thread Tom Lane
Doc: improve explanation of type interval, especially extract(). The explanation of interval's behavior in datatype.sgml wasn't wrong exactly, but it was unclear, partly because it buried the lede about there being three internal fields. Rearrange and wordsmith for more clarity. The discussion

pgsql: Doc: improve explanation of type interval, especially extract().

2024-02-20 Thread Tom Lane
Doc: improve explanation of type interval, especially extract(). The explanation of interval's behavior in datatype.sgml wasn't wrong exactly, but it was unclear, partly because it buried the lede about there being three internal fields. Rearrange and wordsmith for more clarity. The discussion

pgsql: Doc: improve explanation of type interval, especially extract().

2024-02-20 Thread Tom Lane
Doc: improve explanation of type interval, especially extract(). The explanation of interval's behavior in datatype.sgml wasn't wrong exactly, but it was unclear, partly because it buried the lede about there being three internal fields. Rearrange and wordsmith for more clarity. The discussion

pgsql: Doc: correct minor error in back-branch release notes.

2024-02-20 Thread Tom Lane
Doc: correct minor error in back-branch release notes. Commits 1b2c6b756 et al affected the core BRIN "bloom" opclasses, not contrib/bloom. This only corrected a bad assertion so it's not too significant to end users, but since we documented it we should do so accurately. Spotted by Takatsuka

pgsql: Doc: correct minor error in back-branch release notes.

2024-02-20 Thread Tom Lane
Doc: correct minor error in back-branch release notes. Commits 1b2c6b756 et al affected the core BRIN "bloom" opclasses, not contrib/bloom. This only corrected a bad assertion so it's not too significant to end users, but since we documented it we should do so accurately. Spotted by Takatsuka

pgsql: Doc: correct minor error in back-branch release notes.

2024-02-20 Thread Tom Lane
Doc: correct minor error in back-branch release notes. Commits 1b2c6b756 et al affected the core BRIN "bloom" opclasses, not contrib/bloom. This only corrected a bad assertion so it's not too significant to end users, but since we documented it we should do so accurately. Spotted by Takatsuka

pgsql: Replace relids in lateral subquery parse tree during SJE

2024-02-20 Thread Alexander Korotkov
Replace relids in lateral subquery parse tree during SJE Reported-by: Alexander Lakhin Discussion: https://postgr.es/m/56ee4520-e9d1-d519-54fe-c8bff880ce9b%40gmail.com Author: Alexander Korotkov, Andrei Lepikhov Branch -- master Details ---

pgsql: Revert "Improve compression and storage support with inheritance

2024-02-20 Thread Peter Eisentraut
Revert "Improve compression and storage support with inheritance" This reverts commit 0413a556990ba628a3de8a0b58be020fd9a14ed0. pg_dump cannot currently dump all the structures that are allowed by this patch. This needs more work in pg_dump and more test coverage. Discussion: