pgsql: pg_rewind: Remove notice in docs about running CHECKPOINT after

2023-02-26 Thread Heikki Linnakangas
pg_rewind: Remove notice in docs about running CHECKPOINT after promote. Commit 009746 made it unnecessary. pg_rewind now works on a recently promoted standby. Author: Kyotaro Horiguchi, Keisuke Kuroda Discussion:

pgsql: Update types in smgr API

2023-02-26 Thread Peter Eisentraut
Update types in smgr API Change data buffer to void *, from char *, and add const where appropriate. This makes it match the File API (see also 2d4f1ba6cfc2f0a977f1c30bda9848041343e248) and stdio. Discussion:

pgsql: Change xl_hash_vacuum_one_page.ntuples from int to uint16.

2023-02-26 Thread Amit Kapila
Change xl_hash_vacuum_one_page.ntuples from int to uint16. This will create two bytes of padding space in xl_hash_vacuum_one_page which can be used for future patches. This makes the datatype of xl_hash_vacuum_one_page.ntuples same as gistxlogDelete.ntodelete which is advisable as both are used

pgsql: Silence more compiler warnings introduced by d87d548cd0.

2023-02-26 Thread Tom Lane
Silence more compiler warnings introduced by d87d548cd0. Per buildfarm, there are still a couple of functions where we get warnings from compilers that don't know that elog(ERROR) doesn't return. Branch -- master Details ---

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl

2023-02-26 Thread Andrew Dunstan
Don't force SQL_ASCII/no-locale for installcheck in vcregress.pl It's been this way for a very long time, but it appears to have been masking an issue that only manifests with different settings. Therefore, run the tests in the installation's default encoding/locale. Backpatch to all live

pgsql: Doc: Miscellaneous doc updates for MERGE.

2023-02-26 Thread Dean Rasheed
Doc: Miscellaneous doc updates for MERGE. Update a few places in the documentation that should mention MERGE among the list of applicable commands. In a couple of places, a slightly more detailed description of what happens for MERGE seems appropriate. Reviewed by Alvaro Herrera. Discussion:

pgsql: Doc: Miscellaneous doc updates for MERGE.

2023-02-26 Thread Dean Rasheed
Doc: Miscellaneous doc updates for MERGE. Update a few places in the documentation that should mention MERGE among the list of applicable commands. In a couple of places, a slightly more detailed description of what happens for MERGE seems appropriate. Reviewed by Alvaro Herrera. Discussion: