Re: Logical replication and AFTER UPDATE triggers [PG 16]

2024-02-02 Thread Chris Angelico
On Fri, 2 Feb 2024 at 13:20, Chris Angelico wrote: > create or replace function send_settings_notification() returns > trigger language plpgsql as $$begin perform > pg_notify('stillebot.settings', ''); return null; end$$; > create trigger settings_update_notify after update on > stillebot.settings

Logical replication and AFTER UPDATE triggers [PG 16]

2024-02-01 Thread Chris Angelico
After various iterations of logical on PG 15, I bit the bullet and installed PG 16. (Using the bookworm-pgdg repository.) Turns out, that basically solved all the problems I'd been having previously - yay! Got a bit of a curveball thrown at me though. I have a singleton settings table (see other t