pgsql: worker_spi: Rename custom wait event to "WorkerSpiMain"

2023-10-04 Thread Michael Paquier
worker_spi: Rename custom wait event to "WorkerSpiMain" This naming is more consistent with all the other user-facing wait event strings. Other in-core modules will use the same naming convention, so let's be consistent here as well. Extracted from a larger patch by the same author. Author: Mas

pgsql: test_shm_mq: Replace WAIT_EVENT_EXTENSION with custom wait event

2023-10-04 Thread Michael Paquier
test_shm_mq: Replace WAIT_EVENT_EXTENSION with custom wait events Two custom wait events are added here: - "TestShmMqBgWorkerStartup", when setting up a set of bgworkers in wait_for_workers_to_become_ready(). - "TestShmMqMessageQueue", when waiting for a queued message in test_shm_mq_pipelined().

pgsql: doc: Clarify not-null constraints in information schema

2023-10-04 Thread Peter Eisentraut
doc: Clarify not-null constraints in information schema Add a bit of clarification in various places that not-null constraints are included under check constraints in the information schema. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/af2324fabf0020e464b0268be9e

pgsql: Document that --sync-method takes an argument.

2023-10-04 Thread Nathan Bossart
Document that --sync-method takes an argument. This was missed in commit 8c16ad3b43. Reported-by: Robert Haas Reviewed-by: Daniel Gustafsson, Robert Haas, Alvaro Herrera, Tom Lane Discussion: https://postgr.es/m/CA%2BTgmoZi7pcx-ec3oJLWSr2R%3DDn2Zeiyx3EXQKc_1TTvA6Eepg%40mail.gmail.com Branch ---

pgsql: postgres_fdw: Replace WAIT_EVENT_EXTENSION with custom wait even

2023-10-04 Thread Michael Paquier
postgres_fdw: Replace WAIT_EVENT_EXTENSION with custom wait events Three custom wait events are added here: - "PostgresFdwCleanupResult", waiting while cleaning up PQgetResult() on transaction abort. - "PostgresFdwConnect", waiting to establish a connection to a remote server. - "PostgresFdwGetRes

pgsql: dblink: Replace WAIT_EVENT_EXTENSION with custom wait events

2023-10-04 Thread Michael Paquier
dblink: Replace WAIT_EVENT_EXTENSION with custom wait events Two custom wait events are added here: - "DblinkConnect", when waiting to establish a connection to a remote server. - "DblinkGetConnect", when waiting to establish a connection to a remote server but it could not be found in the list of

pgsql: worker_spi: Expand set of options to start workers

2023-10-04 Thread Michael Paquier
worker_spi: Expand set of options to start workers A couple of new options are added to this module to provide more control on the ways bgworkers are started: - A new GUC called worker_spi.role to control which role to use by default when starting a worker. - worker_spi_launch() gains three argume

pgsql: Constify crc32_sz

2023-10-04 Thread Peter Eisentraut
Constify crc32_sz Author: Aleksander Alekseev Discussion: https://postgr.es/m/e08317a0-a2e7-c60d-c14a-ad9fc34f8f6c%40eisentraut.org Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/688926633fc6663d632334b17b34b0384620a458 Modified Files -- contrib/hsto

pgsql: Modernize const handling with readline

2023-10-04 Thread Peter Eisentraut
Modernize const handling with readline The comment /* On some platforms, readline is declared as readline(char *) */ is obsolete. The casting away of const can be removed. The const in the readline() prototype was added in GNU readline 4.2, released in 2001. BSD libedit has also had const