pgsql: Pass Size as a 2nd argument for snprintf() in tablesync.c.

2022-09-20 Thread Amit Kapila
Pass Size as a 2nd argument for snprintf() in tablesync.c. Previously the following snprintf() wrappers: * ReplicationSlotNameForTablesync() * ReplicationOriginNameForTablesync() ... used int as a second argument of snprintf() while the actual type of it is size_t. Although it doesn't fail at

pgsql: Improve some error messages.

2022-09-20 Thread Amit Kapila
Improve some error messages. It is not our usual style to use "we" in the error messages. Author: Kyotaro Horiguchi Reviewed-By: Amit Kapila Discussion: https://postgr.es/m/20220914.111507.13049297635620898.horikyota@gmail.com Branch -- master Details ---

pgsql: Use \b in one more PG_TEST_EXTRA check, oversight in c3382a3c3cc

2022-09-20 Thread Andres Freund
Use \b in one more PG_TEST_EXTRA check, oversight in c3382a3c3cc Per off-list report from Thomas Munro. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/3f0c901e744c87f6e00744e63afe0242d5fe45e9 Modified Files -- src/test/ssl/t/001_ssltests.pl | 2 +- 1

pgsql: Add definition pg_attribute_aligned() for MSVC

2022-09-20 Thread Michael Paquier
Add definition pg_attribute_aligned() for MSVC Visual Studio 2015+ has support for a macro to control the alignement of structures as of __declspec(align(#)), and this commit adds a definition of pg_attribute_aligned() based on that. It happens that this was already used in the implementation of

Re: pgsql: Fix createdb tests for C locale

2022-09-20 Thread Andrew Dunstan
On 2022-09-19 Mo 15:46, Peter Eisentraut wrote: > On 17.09.22 16:44, Tom Lane wrote: >> Christoph Berg writes: >>> This seems to have broken 15 on apt.pg.o/Debian: >> >> Fails on RHEL8 too, if LANG=C. >> OK if LANG=C.utf8. >> >> (The lack of buildfarm complaints is distressing.  Apparently >>

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Disable -Wdeprecated-non-prototype in the back branches.

2022-09-20 Thread Tom Lane
Disable -Wdeprecated-non-prototype in the back branches. There doesn't seem to be any good ABI-preserving way to silence clang 15's -Wdeprecated-non-prototype warnings about our tree-walk APIs. While we've fixed it properly in HEAD, the only way to not see hundreds of these in the back branches

pgsql: Revise tree-walk APIs to improve spec compliance & silence warni

2022-09-20 Thread Tom Lane
Revise tree-walk APIs to improve spec compliance & silence warnings. expression_tree_walker and allied functions have traditionally declared their callback functions as, say, "bool (*walker) ()" to allow for variation in the declared types of the callback functions' context argument. This is

pgsql: Fix recent cpluspluscheck issue in selfuncs.h.

2022-09-20 Thread Peter Geoghegan
Fix recent cpluspluscheck issue in selfuncs.h. Fix selfuncs.h cpluspluscheck complaint, without reintroducing a parameter name inconsistency (restore the original declaration names, and then make corresponding function definitions consistent with that). Oversight in commit a601366a. Author:

Re: pgsql: Harmonize more parameter names in bulk.

2022-09-20 Thread Peter Geoghegan
On Tue, Sep 20, 2022 at 1:47 PM Andres Freund wrote: > This seems to have broken cpluspluscheck: > > https://cirrus-ci.com/task/5694996828389376 Oops. Will fix that now. -- Peter Geoghegan

Re: pgsql: Harmonize more parameter names in bulk.

2022-09-20 Thread Andres Freund
Hi, On 2022-09-20 20:10:38 +, Peter Geoghegan wrote: > Harmonize more parameter names in bulk. This seems to have broken cpluspluscheck: https://cirrus-ci.com/task/5694996828389376 Greetings, Andres Freund

pgsql: Harmonize more parameter names in bulk.

2022-09-20 Thread Peter Geoghegan
Harmonize more parameter names in bulk. Make sure that function declarations use names that exactly match the corresponding names from function definitions in optimizer, parser, utility, libpq, and "commands" code, as well as in remaining library code. Do the same for all code related to

pgsql: Refactor PG_TEST_EXTRA logic in autoconf build

2022-09-20 Thread Andres Freund
Refactor PG_TEST_EXTRA logic in autoconf build To avoid duplicating the PG_TEST_EXTRA logic in Makefiles into the upcoming meson based build definition, move the checks into the the tests themselves. That also has the advantage of making skipped tests visible. Reviewed-by: Peter Eisentraut

pgsql: Improve comment for OAT_POST_CREATE.

2022-09-20 Thread Jeff Davis
Improve comment for OAT_POST_CREATE. Clarify that the command counter may or may not have been incremented. We may want to change the behavior to be more consistent, but until that time, at least improve the comment. Discussion:

pgsql: Fix `trap` in a few shell scripts

2022-09-20 Thread Alvaro Herrera
Fix `trap` in a few shell scripts The original `trap` lines in these scripts are incomplete: in case of any signal, they delete the working directory but let the script run to completion, which is useless because it will only proceed to complain about the working directory being removed. Add

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Suppress variable-set-but-not-used warnings from clang 15.

2022-09-20 Thread Tom Lane
Suppress variable-set-but-not-used warnings from clang 15. clang 15+ will issue a set-but-not-used warning when the only use of a variable is in autoincrements (e.g., "foo++;"). That's perfectly sensible, but it detects a few more cases that we'd not noticed before. Silence the warnings with our

pgsql: Disable autovacuum in MERGE test script

2022-09-20 Thread Alvaro Herrera
Disable autovacuum in MERGE test script Otherwise, it can fail given sufficient bad luck. Backpatch to 15. Discussion: https://postgr.es/m/537759.1663625...@sss.pgh.pa.us Branch -- REL_15_STABLE Details ---

pgsql: Disable autovacuum in MERGE test script

2022-09-20 Thread Alvaro Herrera
Disable autovacuum in MERGE test script Otherwise, it can fail given sufficient bad luck. Backpatch to 15. Discussion: https://postgr.es/m/537759.1663625...@sss.pgh.pa.us Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c9a21fea44ca5722dbfcced0dfdc84db063aff71

pgsql: doc: Fix parameter name for pg_create_logical_replication_slot()

2022-09-20 Thread Michael Paquier
doc: Fix parameter name for pg_create_logical_replication_slot() The parameter controlling if two-phase transactions can be decoded was named "two_phase" in the documentation while its procedure defines "twophase". Author: Florin Irion Discussion:

pgsql: doc: Fix parameter name for pg_create_logical_replication_slot()

2022-09-20 Thread Michael Paquier
doc: Fix parameter name for pg_create_logical_replication_slot() The parameter controlling if two-phase transactions can be decoded was named "two_phase" in the documentation while its procedure defines "twophase". Author: Florin Irion Discussion:

pgsql: doc: Fix parameter name for pg_create_logical_replication_slot()

2022-09-20 Thread Michael Paquier
doc: Fix parameter name for pg_create_logical_replication_slot() The parameter controlling if two-phase transactions can be decoded was named "two_phase" in the documentation while its procedure defines "twophase". Author: Florin Irion Discussion:

Re: pgsql: Add support for MERGE SQL command

2022-09-20 Thread Alvaro Herrera
On 2022-Sep-19, Tom Lane wrote: > I wrote: > > It might be better to change these to temp tables. You'd then > > have to filter the temp schema out of the results; but since you > > have a filtering function anyway, that doesn't seem too hard. > > Or even easier, ALTER TABLE SET

pgsql: Fix incorrect variable types for origin IDs in decode.c

2022-09-20 Thread Michael Paquier
Fix incorrect variable types for origin IDs in decode.c These variables used XLogRecPtr instead of RepOriginId. Author: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoBm-vNyBSXGp4bmJGvhr=S-EGc5q1dtV70cFTcJvLhC=q...@mail.gmail.com Backpatch-through: 14 Branch -- REL_15_STABLE

pgsql: Fix incorrect variable types for origin IDs in decode.c

2022-09-20 Thread Michael Paquier
Fix incorrect variable types for origin IDs in decode.c These variables used XLogRecPtr instead of RepOriginId. Author: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoBm-vNyBSXGp4bmJGvhr=S-EGc5q1dtV70cFTcJvLhC=q...@mail.gmail.com Backpatch-through: 14 Branch -- REL_14_STABLE

pgsql: Fix incorrect variable types for origin IDs in decode.c

2022-09-20 Thread Michael Paquier
Fix incorrect variable types for origin IDs in decode.c These variables used XLogRecPtr instead of RepOriginId. Author: Masahiko Sawada Discussion: https://postgr.es/m/CAD21AoBm-vNyBSXGp4bmJGvhr=S-EGc5q1dtV70cFTcJvLhC=q...@mail.gmail.com Backpatch-through: 14 Branch -- master Details