On 2021-Jul-19, Tomas Vondra wrote: > I have a feeling it's getting overly complicated, to the extent that > it'll be hard to explain to users and reason about. I don't think > there's a "perfect" solution for cases when the filter expression gives > different answers for old/new row - it'll always be surprising for some > users :-( > > So maybe the best thing is to stick to the simple approach already used > e.g. by pglogical, which simply user the new row when available (insert, > update) and old one for deletes.
OK, no objection to that plan. -- Álvaro Herrera 39°49'30"S 73°17'W — https://www.EnterpriseDB.com/ "No es bueno caminar con un hombre muerto"