pgsql: Add cache for recomputeNamespacePath().

2023-11-14 Thread Jeff Davis
Add cache for recomputeNamespacePath(). When search_path is changed to something that was previously set, and no invalidation happened in between, use the cached list of namespace OIDs rather than recomputing them. This avoids syscache lookups and ACL checks. Important when the search_path

pgsql: doc: Improve description of targets for pg_stat_reset_shared()

2023-11-14 Thread Michael Paquier
doc: Improve description of targets for pg_stat_reset_shared() This commit changes the documentation so as the supported targets are documented with itemized list, making it easier to understand the view a given target affects. Author: Atsushi Torikoshi Discussion:

pgsql: Change how a base backup decides which files have checksums.

2023-11-14 Thread Robert Haas
Change how a base backup decides which files have checksums. Previously, it thought that any plain file located under global, base, or a tablespace directory had checksums unless it was in a short list of excluded files. Now, it thinks that files in those directories have checksums if

pgsql: Support +/- infinity in the interval data type.

2023-11-14 Thread Dean Rasheed
Support +/- infinity in the interval data type. This adds support for infinity to the interval data type, using the same input/output representation as the other date/time data types that support infinity. This allows various arithmetic operations on infinite dates, timestamps and intervals. The

pgsql: Fix capitalization of "Tcl"

2023-11-14 Thread Peter Eisentraut
Fix capitalization of "Tcl" Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e7814b40d02582238b14d838c2458825d9170178 Modified Files -- doc/src/sgml/install-windows.sgml | 2 +- doc/src/sgml/xact.sgml| 2 +- src/pl/tcl/pltcl.c|

pgsql: Fix whitespace

2023-11-14 Thread Peter Eisentraut
Fix whitespace Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/43071777be134bb471f316fea66d928e6c40e37f Modified Files -- doc/src/sgml/func.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: doc: Update note about Bison and Flex build requirements

2023-11-14 Thread Peter Eisentraut
doc: Update note about Bison and Flex build requirements Updating the Windows-specific chapter was forgotten by 721856ff24. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/b41b1a7f490093643ce2080d1cf9323e24423eb8 Modified Files --

pgsql: Fix capitalization of "Tcl"

2023-11-14 Thread Peter Eisentraut
Fix capitalization of "Tcl" Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8737faa68edd15e747e29210c87cf040941c34b5 Modified Files -- doc/src/sgml/xact.sgml | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-)

pgsql: Replace Gen_dummy_probes.sed with Gen_dummy_probes.pl

2023-11-14 Thread Peter Eisentraut
Replace Gen_dummy_probes.sed with Gen_dummy_probes.pl To generate a dummy probes.h file when dtrace is not available, we had two different scripts: A sed version, which is the original version, and a Perl version, which was generated by s2p. This split was necessary because Perl was not a