pgsql: Fix comment in guc_tables.c

2022-10-03 Thread Michael Paquier
Fix comment in guc_tables.c s/ERROR_HANDLING/ERROR_HANDLING_OPTIONS/. Author: Peter Smith Discussion: https://postgr.es/m/cahut+ptdj3cv+f0pvisc0xymi2lhgbpqxqwtf0fjisvn_nv...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/bdf9b60085bca2dbb0af920d50f

pgsql: Cleanup useless assignments and checks

2022-10-03 Thread Michael Paquier
Cleanup useless assignments and checks This cleans up a couple of areas: - Remove XLogSegNo calculation for the last WAL segment in backup in xlog.c (7d70809 has moved this logic entirely to xlogbackup.c when building the contents of the backup history file). - Remove check on log_min_duration in

pgsql: Add filtering capability for cross-version pg_upgrade tests

2022-10-03 Thread Michael Paquier
Add filtering capability for cross-version pg_upgrade tests This commit expands the TAP tests of pg_upgrade when running these with different major versions for the "old" cluster (to-be-upgraded) and the "new" cluster (upgraded-to), by backporting some of the buildfarm facilities directory into th

pgsql: meson: llvm: Use llvm-config's --cxxflags when building llvmjit

2022-10-03 Thread Andres Freund
meson: llvm: Use llvm-config's --cxxflags when building llvmjit Otherwise we don't use LLVM's flags when building llvmjit_wrap.cpp and llvmjit_inline.cpp. That can cause compile time failures if the C++ compiler doesn't default to a new enough C++ standards version and link time failures due to AB

pgsql: Stamp 15rc2.

2022-10-03 Thread Tom Lane
Stamp 15rc2. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2a40d040c924b1707cd03a9c66c80fcc4795c2d1 Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

Re: pgsql: Avoid improbable PANIC during heap_update.

2022-10-03 Thread Jaime Casanova
On Fri, Sep 30, 2022 at 04:51:20PM -0400, Tom Lane wrote: > Jaime Casanova writes: > > Just to confirm I saw this on RC1 > > What test case are you using? > Hi, Currently the way I have to reproduce it is: - install the regression database - drop all tables but: hash_i4_heap, hash_na

pgsql: Fix psql's behavior with \g for a multiple-command string.

2022-10-03 Thread Tom Lane
Fix psql's behavior with \g for a multiple-command string. The pre-v15 behavior was to discard all but the last result, but with the new behavior of printing all results by default, we will send each such result to the \g file. However, we're still opening and closing the \g file for each result,

pgsql: Fix psql's behavior with \g for a multiple-command string.

2022-10-03 Thread Tom Lane
Fix psql's behavior with \g for a multiple-command string. The pre-v15 behavior was to discard all but the last result, but with the new behavior of printing all results by default, we will send each such result to the \g file. However, we're still opening and closing the \g file for each result,

pgsql: meson: respect -Dldap=disabled

2022-10-03 Thread Andres Freund
meson: respect -Dldap=disabled I noticed during some manual testing that -Dldap=disabled (or --auto-features=disabled) doesn't disable ldap if available - that's obviously wrong. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/0ae5db28d06939d1a2ac52813629be0dfc77010

pgsql: Doc: update v15 release notes.

2022-10-03 Thread Tom Lane
Doc: update v15 release notes. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b1c73e1cf1ffdfedeed4f2cd7f34247dcad308bf Modified Files -- doc/src/sgml/release-15.sgml | 20 +--- 1 file changed, 1 insertion(+), 19 deletions(-)

pgsql: Revert "Optimize order of GROUP BY keys".

2022-10-03 Thread Tom Lane
Revert "Optimize order of GROUP BY keys". This reverts commit db0d67db2401eb6238ccc04c6407a4fd4f985832 and several follow-on fixes. The idea of making a cost-based choice of the order of the sorting columns is not fundamentally unsound, but it requires cost information and data statistics that we

pgsql: Revert "Optimize order of GROUP BY keys".

2022-10-03 Thread Tom Lane
Revert "Optimize order of GROUP BY keys". This reverts commit db0d67db2401eb6238ccc04c6407a4fd4f985832 and several follow-on fixes. The idea of making a cost-based choice of the order of the sorting columns is not fundamentally unsound, but it requires cost information and data statistics that we

pgsql: Add authentication TAP test for peer authentication

2022-10-03 Thread Michael Paquier
Add authentication TAP test for peer authentication This commit introduces an authentication test for the peer method, as of a set of scenarios with and without a user name map. The script is automatically skipped if peer is not supported in the environment where this test is run, checking this b