pgsql: Update copyright notice to 2022 for recently-introduced TAP test

2022-01-16 Thread Michael Paquier
Update copyright notice to 2022 for recently-introduced TAP test Subscription test 027_nosuperuser.pl has been introduced in a2ab9c0, after the notices got refreshed to 2022 in 27b77ec. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/e701bdd2f042829402d96589cb16ae21

pgsql: Add stxdinherit flag to pg_statistic_ext_data

2022-01-16 Thread Tomas Vondra
Add stxdinherit flag to pg_statistic_ext_data Add pg_statistic_ext_data.stxdinherit flag, so that for each extended statistics definition we can store two versions of data - one for the relation alone, one for the whole inheritance tree. This is analogous to pg_statistic.stainherit, but we failed

pgsql: Clean up TAP tests' usage of wait_for_catchup().

2022-01-16 Thread Tom Lane
Clean up TAP tests' usage of wait_for_catchup(). By default, wait_for_catchup() waits for the replication connection to reach the primary's write LSN. That's fine, but in an apparent attempt to save one query round-trip, it was coded so that we executed pg_current_wal_lsn() again during each prob

pgsql: Fix psql's tab-completion of enum label values.

2022-01-16 Thread Tom Lane
Fix psql's tab-completion of enum label values. Since enum labels have to be single-quoted, this part of the tab completion machinery got side-swiped by commit cd69ec66c. A side-effect of that commit is that (at least with some versions of Readline) the text string passed for completion will omit

pgsql: Fix psql's tab-completion of enum label values.

2022-01-16 Thread Tom Lane
Fix psql's tab-completion of enum label values. Since enum labels have to be single-quoted, this part of the tab completion machinery got side-swiped by commit cd69ec66c. A side-effect of that commit is that (at least with some versions of Readline) the text string passed for completion will omit

pgsql: Fix psql's tab-completion of enum label values.

2022-01-16 Thread Tom Lane
Fix psql's tab-completion of enum label values. Since enum labels have to be single-quoted, this part of the tab completion machinery got side-swiped by commit cd69ec66c. A side-effect of that commit is that (at least with some versions of Readline) the text string passed for completion will omit

pgsql: Teach hash_ok_operator() that record_eq is only sometimes hashab

2022-01-16 Thread Tom Lane
Teach hash_ok_operator() that record_eq is only sometimes hashable. The need for this was foreseen long ago, but when record_eq actually became hashable (in commit 01e658fa7), we missed updating this spot. Per bug #17363 from Elvis Pranskevichus. Back-patch to v14 where the faulty commit came in

pgsql: Teach hash_ok_operator() that record_eq is only sometimes hashab

2022-01-16 Thread Tom Lane
Teach hash_ok_operator() that record_eq is only sometimes hashable. The need for this was foreseen long ago, but when record_eq actually became hashable (in commit 01e658fa7), we missed updating this spot. Per bug #17363 from Elvis Pranskevichus. Back-patch to v14 where the faulty commit came in

pgsql: Introduce log_destination=jsonlog

2022-01-16 Thread Michael Paquier
Introduce log_destination=jsonlog "jsonlog" is a new value that can be added to log_destination to provide logs in the JSON format, with its output written to a file, making it the third type of destination of this kind, after "stderr" and "csvlog". The format is convenient to feed logs to other

pgsql: Consistently use the function name CreateCheckPoint in code and

2022-01-16 Thread Amit Kapila
Consistently use the function name CreateCheckPoint in code and comments. Author: Bharath Rupireddy Discussion: https://postgr.es/m/CALj2ACVZmKsvDjtd45+9oTcnjUJtC4LF2BYK8TpWT1f=njj...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/4c004dd520fcf262ba

pgsql: Test replay of regression tests, attempt II.

2022-01-16 Thread Thomas Munro
Test replay of regression tests, attempt II. See commit message for 123828a7fa563025d0ceee10cf1b2a253cd05319. The only change this time is the order of the arguments passed to pg_regress. The previously version broke in the build farm environment due to the contents of EXTRA_REGRESS_OPTS (see al

pgsql: Add support for --no-table-access-method in pg_{dump,dumpall,res

2022-01-16 Thread Michael Paquier
Add support for --no-table-access-method in pg_{dump,dumpall,restore} The logic is similar to default_tablespace in some ways, so as no SET queries on default_table_access_method are generated before dumping or restoring an object (table or materialized view support table AMs) when specifying this

Re: pgsql: Test replay of regression tests, attempt II.

2022-01-16 Thread Michael Paquier
On Mon, Jan 17, 2022 at 03:35:48AM +, Thomas Munro wrote: > Test replay of regression tests, attempt II. > > See commit message for 123828a7fa563025d0ceee10cf1b2a253cd05319. The > only change this time is the order of the arguments passed to > pg_regress. The previously version broke in the

pgsql: Fix typo in pg_dumpall.c

2022-01-16 Thread Michael Paquier
Fix typo in pg_dumpall.c Oversight in 2158628. Reported-by: Justin Pryzby Discussion: https://postgr.es/m/20220117062006.gy14...@telsasoft.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/ca86a63d207aca1f52ff13a1ce13854681d1bbf9 Modified Files -- sr