• Amit Kapila's avatar
    Fix partition table's REPLICA IDENTITY checking on the subscriber. · 52d5ea9a
    Amit Kapila authored
    In logical replication, we will check if the target table on the
    subscriber is updatable by comparing the replica identity of the table on
    the publisher with the table on the subscriber. When the target table is a
    partitioned table, we only check its replica identity but not for the
    partition tables. This leads to assertion failure while applying changes
    for update/delete as we expect those to succeed only when the
    corresponding partition table has a primary key or has a replica
    identity defined.
    
    Fix it by checking the replica identity of the partition table while
    applying changes.
    
    Reported-by: Shi Yu
    Author: Shi Yu, Hou Zhijie
    Reviewed-by: Amit Langote, Amit Kapila
    Backpatch-through: 13, where it was introduced
    Discussion: https://postgr.es/m/OSZPR01MB6310F46CD425A967E4AEF736FDA49@OSZPR01MB6310.jpnprd01.prod.outlook.com
    52d5ea9a
relation.c 18.3 KB