pgsql: Allow specifying column lists for logical replication

2022-03-25 Thread Tomas Vondra
Allow specifying column lists for logical replication This allows specifying an optional column list when adding a table to logical replication. The column list may be specified after the table name, enclosed in parentheses. Columns not included in this list are not sent to the subscriber, allowin

pgsql: Minor improvements in sequence decoding code and docs

2022-03-25 Thread Tomas Vondra
Minor improvements in sequence decoding code and docs A couple minor comment improvements and code cleanups, based on post-commit feedback to the sequence decoding patch. Author: Amit Kapila, vignesh C Discussion: https://postgr.es/m/[email protected] Branch

pgsql: Harden TAP tests that intentionally corrupt page checksums.

2022-03-25 Thread Tom Lane
Harden TAP tests that intentionally corrupt page checksums. The previous method for doing that was to write zeroes into a predetermined set of page locations. However, there's a roughly 1-in-64K chance that the existing checksum will match by chance, and yesterday several buildfarm animals starte

pgsql: Harden TAP tests that intentionally corrupt page checksums.

2022-03-25 Thread Tom Lane
Harden TAP tests that intentionally corrupt page checksums. The previous method for doing that was to write zeroes into a predetermined set of page locations. However, there's a roughly 1-in-64K chance that the existing checksum will match by chance, and yesterday several buildfarm animals starte

pgsql: Harden TAP tests that intentionally corrupt page checksums.

2022-03-25 Thread Tom Lane
Harden TAP tests that intentionally corrupt page checksums. The previous method for doing that was to write zeroes into a predetermined set of page locations. However, there's a roughly 1-in-64K chance that the existing checksum will match by chance, and yesterday several buildfarm animals starte

pgsql: Harden TAP tests that intentionally corrupt page checksums.

2022-03-25 Thread Tom Lane
Harden TAP tests that intentionally corrupt page checksums. The previous method for doing that was to write zeroes into a predetermined set of page locations. However, there's a roughly 1-in-64K chance that the existing checksum will match by chance, and yesterday several buildfarm animals starte

pgsql: Harden TAP tests that intentionally corrupt page checksums.

2022-03-25 Thread Tom Lane
Harden TAP tests that intentionally corrupt page checksums. The previous method for doing that was to write zeroes into a predetermined set of page locations. However, there's a roughly 1-in-64K chance that the existing checksum will match by chance, and yesterday several buildfarm animals starte

pgsql: Handle sequences in preprocess_pubobj_list

2022-03-25 Thread Tomas Vondra
Handle sequences in preprocess_pubobj_list Commit 75b1521dae added support for logical replication of sequences, including grammar changes, but it did not update preprocess_pubobj_list accordingly. This can cause segfaults with "continuations", i.e. when command specifies a list of objects: CRE

pgsql: Update tab-completion for CREATE PUBLICATION with sequences

2022-03-25 Thread Tomas Vondra
Update tab-completion for CREATE PUBLICATION with sequences Commit 75b1521dae added support for sequences to built-in replication, but the tab-completion was updated only for ALTER PUBLICATION, not for CREATE PUBLICATION. Report and patch by Masahiko Sawada. Author: Masahiko Sawada Discussion:

pgsql: Fix replay of create database records on standby

2022-03-25 Thread Alvaro Herrera
Fix replay of create database records on standby Crash recovery on standby may encounter missing directories when replaying create database WAL records. Prior to this patch, the standby would fail to recover in such a case. However, the directories could be legitimately missing. Consider a sequ

pgsql: Fix replay of create database records on standby

2022-03-25 Thread Alvaro Herrera
Fix replay of create database records on standby Crash recovery on standby may encounter missing directories when replaying create database WAL records. Prior to this patch, the standby would fail to recover in such a case. However, the directories could be legitimately missing. Consider a sequ

pgsql: Fix replay of create database records on standby

2022-03-25 Thread Alvaro Herrera
Fix replay of create database records on standby Crash recovery on standby may encounter missing directories when replaying create database WAL records. Prior to this patch, the standby would fail to recover in such a case. However, the directories could be legitimately missing. Consider a sequ

pgsql: Make update-unicode target work in vpath builds

2022-03-25 Thread Peter Eisentraut
Make update-unicode target work in vpath builds Author: Andres Freund Discussion: https://www.postgresql.org/message-id/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/c64fb698d076b297b350f667719ba5d58551a7f9

pgsql: Refactor DLSUFFIX handling

2022-03-25 Thread Peter Eisentraut
Refactor DLSUFFIX handling Move DLSUFFIX from makefiles into header files for all platforms. Move the DLSUFFIX assignment from src/makefiles/ to src/templates/, have configure read it, and then substitute it into Makefile.global and pg_config.h. This avoids the need for all makefile rules that ne