undefined | Better HN

0 pointsanarazel7y ago0 comments

> 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.

0 comments

vsurabhi7y ago

That'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).

j / k navigate · click thread line to collapse