pgsql: Default to dynamic_shared_memory_type=sysv on Solaris.

2022-07-01 Thread Thomas Munro
Default to dynamic_shared_memory_type=sysv on Solaris. POSIX shm_open() can sleep for a long time and fail spuriously because of contention on an internal lock file on Solaris (and presumably illumos). Commit 389869af fixed the main problem with this, namely that we could crash, but it's now clea

pgsql: Default to dynamic_shared_memory_type=sysv on Solaris.

2022-07-01 Thread Thomas Munro
Default to dynamic_shared_memory_type=sysv on Solaris. POSIX shm_open() can sleep for a long time and fail spuriously because of contention on an internal lock file on Solaris (and presumably illumos). Commit 389869af fixed the main problem with this, namely that we could crash, but it's now clea

pgsql: Introduce pg_attribute_nonnull(...)

2022-07-01 Thread Michael Paquier
Introduce pg_attribute_nonnull(...) pg_attribute_nonnull(...) can be used to generate compiler warnings when a function is called with the specified arguments set to NULL, as per an idea from Andres Freund. An empty argument list indicates that no pointer arguments can be NULL. pg_attribute_nonn

pgsql: Fix race condition in t/028_pitr_timelines.pl.

2022-07-01 Thread Noah Misch
Fix race condition in t/028_pitr_timelines.pl. Per buildfarm members sungazer and mylodon. Back-patch to v15, which introduced this test. Discussion: https://postgr.es/m/20220627070457.ga2176...@rfd.leadboat.com Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdi

pgsql: Fix race condition in t/028_pitr_timelines.pl.

2022-07-01 Thread Noah Misch
Fix race condition in t/028_pitr_timelines.pl. Per buildfarm members sungazer and mylodon. Back-patch to v15, which introduced this test. Discussion: https://postgr.es/m/20220627070457.ga2176...@rfd.leadboat.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4f4c

pgsql: Replace PGISOLATIONTIMEOUT with 2 * PG_TEST_TIMEOUT_DEFAULT.

2022-07-01 Thread Noah Misch
Replace PGISOLATIONTIMEOUT with 2 * PG_TEST_TIMEOUT_DEFAULT. Now that the more-generic variable exists, use it. Discussion: https://postgr.es/m/20220219024136.ga3670...@rfd.leadboat.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c99c67fc43f8659517310c62e8a2637

pgsql: Remove no-longer-used parameter for create_groupingsets_path().

2022-07-01 Thread Tom Lane
Remove no-longer-used parameter for create_groupingsets_path(). numGroups is unused since commit b5635948a; let's get rid of it. XueJing Zhao, reviewed by Richard Guo Discussion: https://postgr.es/m/dm6pr05mb64923cc8b63a2caf3b2e5d47b7...@dm6pr05mb6492.namprd05.prod.outlook.com Branch -- ma

pgsql: Add missing GETTEXT_FLAGS entry

2022-07-01 Thread Peter Eisentraut
Add missing GETTEXT_FLAGS entry Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/f58f1fb6c0f0990558d0859018b31412b1338447 Modified Files -- src/bin/psql/nls.mk | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-)

pgsql: Add missing GETTEXT_FLAGS entry

2022-07-01 Thread Peter Eisentraut
Add missing GETTEXT_FLAGS entry Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/37ef8e1dfe37b02212755eb8797d7b2598b46b96 Modified Files -- src/bin/psql/nls.mk | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-)

pgsql: doc: Add index entry for MERGE SQL command.

2022-07-01 Thread Fujii Masao
doc: Add index entry for MERGE SQL command. Back-patch to v15, where MERGE command was supported. Author: Fujii Masao Reviewed-by: Alvaro Herrera Discussion: https://postgr.es/m/4e7a4b38-c34a-ce2c-c71e-832d2b768...@oss.nttdata.com Branch -- master Details --- https://git.postgresql.org

pgsql: doc: Add index entry for MERGE SQL command.

2022-07-01 Thread Fujii Masao
doc: Add index entry for MERGE SQL command. Back-patch to v15, where MERGE command was supported. Author: Fujii Masao Reviewed-by: Alvaro Herrera Discussion: https://postgr.es/m/4e7a4b38-c34a-ce2c-c71e-832d2b768...@oss.nttdata.com Branch -- REL_15_STABLE Details --- https://git.postgre

pgsql: Add construct_array_builtin, deconstruct_array_builtin

2022-07-01 Thread Peter Eisentraut
Add construct_array_builtin, deconstruct_array_builtin There were many calls to construct_array() and deconstruct_array() for built-in types, for example, when dealing with system catalog columns. These all hardcoded the type attributes necessary to pass to these functions. To simplify this a bit