pgsql: Remove obsolete comment

2022-04-01 Thread Peter Eisentraut
Remove obsolete comment accidentally left behind by 4cb658af70027c3544fb843d77b2e84028762747 Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/db086de5abe5d87b07cddd030092b1f81f99c5ea Modified Files -- src/include/utils/rel.h | 1 - 1 file changed, 1 delet

pgsql: Remove obsolete comment

2022-04-01 Thread Peter Eisentraut
Remove obsolete comment accidentally left behind by 4cb658af70027c3544fb843d77b2e84028762747 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8f4b5b09096ae5e470c6410312c24581da319733 Modified Files -- src/include/utils/rel.h | 1 - 1 file changed,

pgsql: Remove obsolete comment

2022-04-01 Thread Peter Eisentraut
Remove obsolete comment accidentally left behind by 4cb658af70027c3544fb843d77b2e84028762747 Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/d480ae069e6c13dcb719b8c6aaf7a5540196a1b3 Modified Files -- src/include/utils/rel.h | 1 - 1 file changed,

Re: pgsql: SQL/JSON query functions

2022-04-01 Thread Tom Lane
Michael Paquier writes: > On Tue, Mar 29, 2022 at 08:57:37PM +, Andrew Dunstan wrote: >> SQL/JSON query functions > Some of the tests introduced in this commit are a bit unstable when > run through a primary/standby setup. Yeah, looks like some of these queries need an ORDER BY.

Re: pgsql: SQL/JSON query functions

2022-04-01 Thread Michael Paquier
Hi Andrew, On Tue, Mar 29, 2022 at 08:57:37PM +, Andrew Dunstan wrote: > SQL/JSON query functions > > This introduces the SQL/JSON functions for querying JSON data using > jsonpath expressions. The functions are: > > JSON_EXISTS() > JSON_QUERY() > JSON_VALUE() > > All of these functions onl

pgsql: Make upgradecheck a no-op in MSVC's vcregress.pl

2022-04-01 Thread Michael Paquier
Make upgradecheck a no-op in MSVC's vcregress.pl 322becb has changed upgradecheck to use the TAP tests, discarding pg_upgrade's tests in bincheck. However, this is proving to be a bad idea for the Windows buildfarm clients that use MSVC when TAP tests are disabled as this causes a hard failure at

pgsql: pageinspect: Use better macros to get special page area for GIN

2022-04-01 Thread Michael Paquier
pageinspect: Use better macros to get special page area for GIN and GiST These five code paths are the last ones that made use of PageGetSpecialPointer() to get the special area of such pages, while those index AMs have already macros to do this job. Noticed while reviewing the use PageGetSpecial

Re: pgsql: Add function to pump IPC process until string match

2022-04-01 Thread Andres Freund
On 2022-03-31 00:00:52 +0200, Daniel Gustafsson wrote: > I'll add diag output on failures along the lines of the diff from earlier > today > but with the regex as well (which Alvarao also requested), but tomorrow > morning > once coffee has been consumed. Thanks for doing that!

pgsql: libpq: Fix pkg-config without OpenSSL

2022-04-01 Thread Peter Eisentraut
libpq: Fix pkg-config without OpenSSL Do not add OpenSSL dependencies to libpq pkg-config file if OpenSSL is not enabled. Oversight in beff361bc1edc24ee5f8b2073a1e5e4c92ea66eb. Author: Fabrice Fontaine Discussion: https://www.postgresql.org/message-id/flat/20220331163759.32665-1-fontaine.fabri

pgsql: libpq: Fix pkg-config without OpenSSL

2022-04-01 Thread Peter Eisentraut
libpq: Fix pkg-config without OpenSSL Do not add OpenSSL dependencies to libpq pkg-config file if OpenSSL is not enabled. Oversight in beff361bc1edc24ee5f8b2073a1e5e4c92ea66eb. Author: Fabrice Fontaine Discussion: https://www.postgresql.org/message-id/flat/20220331163759.32665-1-fontaine.fabri

pgsql: Set minimum required version of zstd as 1.4.0.

2022-04-01 Thread Tom Lane
Set minimum required version of zstd as 1.4.0. It emerges that our new zstd code depends on features that were not present (or at least not enabled by default) in zstd before 1.4.0. That's already four years old, so there's little reason to try to make our code work with something older. Instead

pgsql: libpq: Allow IP address SANs in server certificates

2022-04-01 Thread Peter Eisentraut
libpq: Allow IP address SANs in server certificates The current implementation supports exactly one IP address in a server certificate's Common Name, which is brittle (the strings must match exactly). This patch adds support for IPv4 and IPv6 addresses in a server's Subject Alternative Names. Pe

pgsql: docs: Changing column type doesn't always require an index rebui

2022-04-01 Thread Robert Haas
docs: Changing column type doesn't always require an index rebuild. James Coleman and Robert Haas, reviewed by Matthias van de Meent. Discussion: https://postgr.es/m/CAAaqYe90Ea3RG=A7H-ONvTcx549-oQhp07BrHErwM=ayh2x...@mail.gmail.com Branch -- master Details --- https://git.postgresql.o

pgsql: Add SSL tests for IP addresses in certificates

2022-04-01 Thread Peter Eisentraut
Add SSL tests for IP addresses in certificates This tests some scenarios that already work. A subsequent patch will introduce more functionality. Author: Jacob Champion Co-authored-by: Kyotaro Horiguchi Co-authored-by: Daniel Gustafsson Discussion: https://www.postgresql.org/message-id/flat/

pgsql: psql: Refactor ProcessResult()

2022-04-01 Thread Peter Eisentraut
psql: Refactor ProcessResult() Separate HandleCopyResult() from ProcessResult() in preparation for a subsequent patch. Author: Fabien COELHO Discussion: https://www.postgresql.org/message-id/flat/alpine.DEB.2.21.1904132231510.8961@lancre Branch -- master Details --- https://git.postgr