Now PostgreSQL comes with event triggers, I think we should consider to
support it at our next major release. Here's my idea for the first
version implementation. Any suggestions/ideas are welcome.
1. Event trigger definitions in pg_event_trigger catalog itself will be
propagated to all the nodes. We can use existing infrastructure for this
(maybe we can exclude datanodes from such propagation though...)
2. Event trigger will be fired only at the originating coordinator.
Trigger function can get XC cluster configuration and determine what they
should do with other nodes if necessary. It makes event trigger function
design simpler.
Regards;
---
Koichi Suzuki
|
