Horton

Fix error with CREATE PUBLICATION, wal_level=minimal, and new tables.

Noah Misch <noah@leadboat.com>

View on postgr.es
Commit: e8e3e67490f593a3669c762b50b2aa3a11208654
Author: Noah Misch <noah@leadboat.com>
Date: 2021-01-30T08:12:05Z
Releases: 13.2 
Fix error with CREATE PUBLICATION, wal_level=minimal, and new tables.

CREATE PUBLICATION has failed spuriously when applied to a permanent
relation created or rewritten in the current transaction.  Make the same
change to another site having the same semantic intent; the second
instance has no user-visible consequences.  Back-patch to v13, where
commit c6b92041d38512a4176ed76ad06f713d2e6c01a8 broke this.

Kyotaro Horiguchi

Discussion: https://postgr.es/m/20210113.160705.2225256954956139776.horikyota.ntt@gmail.com

Files

PathChange+/−
src/backend/catalog/pg_publication.c modified +1 −1
src/backend/optimizer/util/plancat.c modified +2 −1
src/test/subscription/t/001_rep_changes.pl modified +19 −1

Discussion