| From: | Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | logical replication does not fire per-column triggers |
| Date: | 2019-12-13 13:25:47 |
| Message-ID: | 21673e2d-597c-6afe-637e-e8b10425b240@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
A patch along these lines is also necessary to handle triggers involving
generated columns in the apply worker. I'll work on that separately.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| 0001-Have-logical-replication-subscriber-fire-column-trig.patch | text/plain | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-12-13 13:28:50 | Re: error context for vacuum to include block number |
| Previous Message | Heikki Linnakangas | 2019-12-13 13:14:08 | Re: automating pg_config.h.win32 maintenance |