Re: logical replication does not fire per-column triggers

2020-01-06 Thread Peter Eisentraut
On 2019-12-16 14:37, Peter Eisentraut wrote: New patch attached. I have committed this and backpatched it to PG10. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Re: logical replication does not fire per-column triggers

2019-12-16 Thread Peter Eisentraut
On 2019-12-14 03:13, Euler Taveira wrote: Using the regression test example, table tab_fk_ref have columns id and bid. If you add a trigger "BEFORE UPDATE OF bid" into subscriber that fires on replica, it will always fire even if you are **not** changed bid in publisher. In logical replication pr

Re: logical replication does not fire per-column triggers

2019-12-13 Thread Euler Taveira
Em sex., 13 de dez. de 2019 às 10:26, Peter Eisentraut escreveu: > > The logical replication subscription side does not fire per-column > update triggers when applying an update change. (Per-table update > triggers work fine.) This patch fixes that. Should be backpatched to PG10. > Using the re