On 20 June 2017 at 09:47, Andres Freund <and...@anarazel.de> wrote: > On 2017-06-20 09:45:27 +0800, Craig Ringer wrote: >> I frequently want to be able to use REPLICA IDENTITY DEFAULT, but also >> record the whole old tuple not just keys, so they can be used in >> conflict processing etc. > > What stops you from automatically using a candidate key if available?
Nothing, and that's what I do. I just think it's a bit fuzzy. Maybe I'm misunderstanding the purpose of REPLICA IDENTITY, but I read it as saying "this is the replication key for this relation". If you use REPLICA IDENTITY FULL then the replication tool goes "nah, I think I'll pick the PK instead" is that really right? It's not a major issue. -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers