pgsql: Use WaitLatch() instead of pg_usleep() at end-of-vacuum truncati

2021-07-01 Thread Michael Paquier
Use WaitLatch() instead of pg_usleep() at end-of-vacuum truncation This has the advantage to make a process more responsive when the postmaster dies, even if the wait time was rather limited as there was only a 50ms timeout here. Another advantage of this change is for monitoring, as we gain a ne

pgsql: Remove some dead stores.

2021-07-01 Thread Thomas Munro
Remove some dead stores. Remove redundant local variable assignments left behind by commit 2fc7af5e966. Author: Quan Zongliang Reviewed-by: Jacob Champion Discussion: https://postgr.es/m/de141d14-4fd6-3148-99bf-856b71aa948a%40yeah.net Branch -- master Details --- https://git.postgresq

pgsql: Simplify error handing of jsonapi.c for the frontend

2021-07-01 Thread Michael Paquier
Simplify error handing of jsonapi.c for the frontend This commit removes a dependency to the central logging facilities in the JSON parsing routines of src/common/, which existed to log errors when seeing error codes that do not match any existing values in JsonParseErrorType, which is not somethi

pgsql: doc: update PG 14 release notes

2021-07-01 Thread Bruce Momjian
doc: update PG 14 release notes Mostly addition of tags Reported-by: Justin Pryzby Discussion: https://postgr.es/m/[email protected] Backpatch-through: 14 only Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/a3a681f8590d9476c8ce9417231

pgsql: doc: Remove inappropriate tags

2021-07-01 Thread Peter Eisentraut
doc: Remove inappropriate tags Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/fb72a7b8c384e25d752b22a69e77d8227af65b4b Modified Files -- doc/src/sgml/brin.sgml | 2 +- doc/src/sgml/datatype.sgml | 2 +- doc/src/sgml/release-14.sgml | 2 +-

pgsql: doc: Remove inappropriate tags

2021-07-01 Thread Peter Eisentraut
doc: Remove inappropriate tags Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/1708f6b38aaf1b9375b5ca82792425410c98d441 Modified Files -- doc/src/sgml/brin.sgml | 2 +- doc/src/sgml/datatype.sgml | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/4180417482b046af2efb6478e2bda4fb0787868e Modified Files -- doc/src/sgml/installation.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8d2be1402833a8cf0876282165bc8eae224a9c2e Modified Files -- GNUmakefile.in | 10 -- doc/src/sgml/installation.sgml | 10 ++ 2 files

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL9_6_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1f7ea06d7eedd37e5e6bf8ddeaf14d3c303c596a Modified Files -- doc/src/sgml/installation.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/7355c241ed002496d70882eccea6027726e2fb5a Modified Files -- GNUmakefile.in | 10 -- doc/src/sgml/installation.sgml | 10 ++ 2 files change

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL_10_STABLE Details --- https://git.postgresql.org/pg/commitdiff/177531ee0ef44ba55b24deb29a8820d19defac50 Modified Files -- doc/src/sgml/installation.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1da2ea07f9ce5eed3d6e62cba785e82a6a0d Modified Files -- GNUmakefile.in | 10 -- doc/src/sgml/installation.sgml | 10 ++ 2 files

pgsql: add missing tag from commit b8c4261e5e

2021-07-01 Thread Andrew Dunstan
add missing tag from commit b8c4261e5e Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/383c29d1e88723638eea56091155edc6e801a778 Modified Files -- doc/src/sgml/installation.sgml | 1 + 1 file changed, 1 insertion(+)

pgsql: doc: Clean up title case use

2021-07-01 Thread Peter Eisentraut
doc: Clean up title case use Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/46bbe5d22938496f177706cc87ff64512def Modified Files -- doc/src/sgml/appendix-obsolete-default-roles.sgml | 2 +- doc/src/sgml/btree.sgml | 2

pgsql: doc: Clean up title case use

2021-07-01 Thread Peter Eisentraut
doc: Clean up title case use Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c0fdc963704983ebd5908dc5acfb4d52303091a4 Modified Files -- doc/src/sgml/appendix-obsolete-default-roles.sgml | 2 +- doc/src/sgml/btree.sgml | 2 +- doc/

Re: pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
On 7/1/21 3:15 PM, Andrew Dunstan wrote: > Add new make targets world-bin and install-world-bin > > These are the same as world and install-world respectively, but without > building or installing the documentation. There are many reasons for > wanting to be able to do this, including speed, lack

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add new make targets world-bin and install-world-bin

2021-07-01 Thread Andrew Dunstan
Add new make targets world-bin and install-world-bin These are the same as world and install-world respectively, but without building or installing the documentation. There are many reasons for wanting to be able to do this, including speed, lack of documentation building tools, and wanting to bui

pgsql: Add --clobber-cache option to initdb, for CCA testing.

2021-07-01 Thread Tom Lane
Add --clobber-cache option to initdb, for CCA testing. Commit 4656e3d66 replaced the "#define CLOBBER_CACHE_ALWAYS" testing mechanism with a GUC, which has been a great help for doing cache-clobber testing in more efficient ways; but there is a gap in the implementation. The only way to do cache-

pgsql: Add --clobber-cache option to initdb, for CCA testing.

2021-07-01 Thread Tom Lane
Add --clobber-cache option to initdb, for CCA testing. Commit 4656e3d66 replaced the "#define CLOBBER_CACHE_ALWAYS" testing mechanism with a GUC, which has been a great help for doing cache-clobber testing in more efficient ways; but there is a gap in the implementation. The only way to do cache-

pgsql: Don't reset relhasindex for partitioned tables on ANALYZE

2021-07-01 Thread Alvaro Herrera
Don't reset relhasindex for partitioned tables on ANALYZE Commit 0e69f705cc1a introduced code to analyze partitioned table; however, that code fails to preserve pg_class.relhasindex correctly. Fix by observing whether any indexes exist rather than accidentally falling through to assuming none do.

pgsql: Don't reset relhasindex for partitioned tables on ANALYZE

2021-07-01 Thread Alvaro Herrera
Don't reset relhasindex for partitioned tables on ANALYZE Commit 0e69f705cc1a introduced code to analyze partitioned table; however, that code fails to preserve pg_class.relhasindex correctly. Fix by observing whether any indexes exist rather than accidentally falling through to assuming none do.

pgsql: Improve build-time check that libpq doesn't call exit().

2021-07-01 Thread Tom Lane
Improve build-time check that libpq doesn't call exit(). Further fixes for commit dc227eb82. Per suggestion from Peter Eisentraut, use a stamp-file to control when the check is run, avoiding repeated executions during "make all". Also, remove "-g" switch for nm: it's useless and some versions of

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Fix prove_installcheck to use correct paths when used with PGXS

2021-07-01 Thread Andrew Dunstan
Fix prove_installcheck to use correct paths when used with PGXS The prove_installcheck recipe in src/Makefile.global.in was emitting bogus paths for a couple of elements when used with PGXS. Here we create a separate recipe for the PGXS case that does it correctly. We also take the opportunity to

pgsql: Allow specifying pg_waldump --rmgr option multiple times.

2021-07-01 Thread Heikki Linnakangas
Allow specifying pg_waldump --rmgr option multiple times. Before, if you specified multiple --rmgr options, only the last one took effect. It seems more sensible to select all the specified resource managers. Reviewed-By: Daniel Gustafsson, Julien Rouhaud Discussion: https://www.postgresql.org/m

pgsql: Fix build failure with newer ICU

2021-07-01 Thread Peter Eisentraut
Fix build failure with newer ICU ICU 69 causes compile failures with PostgreSQL 10. ICU 69 has switched to using stdbool.h, which conflicts with the home-made definitions that we used until PostgreSQL 10. Newer PostgreSQL major versions are therefore not affected. (Older PostgreSQL versions don

pgsql: Add tests for UNBOUNDED syntax ambiguity

2021-07-01 Thread Peter Eisentraut
Add tests for UNBOUNDED syntax ambiguity There is a syntactic ambiguity in the SQL standard. Since UNBOUNDED is a non-reserved word, it could be the name of a function parameter and be used as an expression. There is a grammar hack to resolve such cases as the keyword. Add some tests to record