pgsql: Fix comment in fe-connect.c about PQping and pg_ctl

2022-01-06 Thread Michael Paquier
Fix comment in fe-connect.c about PQping and pg_ctl Since f13ea95f, pg_ctl does not use PQping(), but one comment did not get the call. Author: Euler Taveira Discussion: https://postgr.es/m/[email protected] Branch -- master Details --- https://git.p

pgsql: postgres_fdw: Add regression test for postgres_fdw.application_n

2022-01-06 Thread Fujii Masao
postgres_fdw: Add regression test for postgres_fdw.application_name GUC. Commit 449ab63505 added postgres_fdw.application_name GUC that specifies a value for application_name configuration parameter used when postgres_fdw establishes a connection to a foreign server. Also commit 6e0cb3dec1 allowed

pgsql: Add TAP tests for pg_basebackup with compression

2022-01-06 Thread Michael Paquier
Add TAP tests for pg_basebackup with compression pg_basebackup is able to use gzip to compress the contents of backups with the tar format, but there were no tests for that. This adds a minimalistic set of tests to check the contents of such base backups, including sanity checks on the contents g

pgsql: Refactor tar method of walmethods.c to rely on the compression m

2022-01-06 Thread Michael Paquier
Refactor tar method of walmethods.c to rely on the compression method Since d62bcc8, the directory method of walmethods.c uses the compression method to determine which code path to take. The tar method, used by pg_basebackup --format=t, was inconsistent regarding that, as it relied on the compre

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Prevent altering partitioned table's rowtype, if it's used elsew

2022-01-06 Thread Tom Lane
Prevent altering partitioned table's rowtype, if it's used elsewhere. We disallow altering a column datatype within a regular table, if the table's rowtype is used as a column type elsewhere, because we lack code to go around and rewrite the other tables. This restriction should apply to partition

pgsql: Extend psql's \lo_list/\dl to be able to print large objects' AC

2022-01-06 Thread Tom Lane
Extend psql's \lo_list/\dl to be able to print large objects' ACLs. The ACL is printed when you add + to the command, similarly to various other psql backslash commands. Along the way, move the code for this into describe.c, where it is a better fit (and can share some code). Pavel Luzanov, revi