[gigatexal]

Trigger would work. But going the pg_notify approach could allow for asynchronous updating whereas the trigger approach could slow writes.