3 ms·
> Postgres's per statement triggers don't let you capture the rows that are modified They do these days. Since 10 you can specify: REFERENCING { { OLD | NEW
by anarazel 9y ago
> Postgres's per statement triggers don't let you capture the rows that are modified
They do these days. Since 10 you can specify:
REFERENCING { { OLD | NEW } TABLE [ AS ] transition_relation_name } [ ... ] ]
in a FOR EACH STATEMENT ... AFTER trigger.
- vsurabhi 9y agoThat's great news ! So the trigger can use json_agg to compose the notification with all the modified rows. We'll document it (https://github.com/hasura/skor/issues/8 https://github.com/hasura/skor/issues/8).