On Thu, Dec 7, 2017 at 9:43 AM, Petr Jelinek <petr.jeli...@2ndquadrant.com> wrote: > No it won't, it will update only one row, it does not try to find > multiple matching rows.
Good, because that's exactly what it should do. I mean, if you have on the master two tuples that are identical, and you update one of them, then the replica had better update exactly one of them as well. Since they are identical, it doesn't matter *which* one gets updated on the replica, but if you update *both* of them on the replica, then things are out of sync. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
