• Amit Kapila's avatar
    Invalidate all partitions for a partitioned table in publication. · 9eff8593
    Amit Kapila authored
    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
    9eff8593
pg_publication.c 15.3 KB