Thread: pgsql: Invalidate all partitions for a partitioned table in publication
Invalidate all partitions for a partitioned table in publication. Updates/Deletes on a partition were allowed even without replica identity after the parent table was added to a publication. This would later lead to an error on subscribers. The reason was that we were not invalidating the partition's relcache and the publication information for partitions was not getting rebuilt. Similarly, we were not invalidating the partitions' relcache after dropping a partitioned table from a publication which will prohibit Updates/Deletes on its partition without replica identity even without any publication. Reported-by: Haiying Tang Author: Hou Zhijie and Vignesh C Reviewed-by: Vignesh C and Amit Kapila Backpatch-through: 13 Discussion: https://postgr.es/m/OS0PR01MB6113D77F583C922F1CEAA1C3FBD29@OS0PR01MB6113.jpnprd01.prod.outlook.com Branch ------ REL_13_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/f09a81f1c08fa5c2fed12bed88d53a11a72ff993 Modified Files -------------- src/backend/catalog/pg_publication.c | 82 ++++++++++++++++++++----------- src/backend/commands/publicationcmds.c | 57 ++++++++++++--------- src/include/catalog/pg_publication.h | 3 ++ src/include/commands/publicationcmds.h | 5 ++ src/test/regress/expected/publication.out | 13 ++++- src/test/regress/sql/publication.sql | 11 ++++- 6 files changed, 116 insertions(+), 55 deletions(-)