On 14 Sep. 2016 9:44 am, "Alvaro Herrera" <alvhe...@2ndquadrant.com> wrote: > > Tatsuo Ishii wrote: > > Simple question: Is there any reason for event trigger to not support > > CREATE/ALTER ROLE/USER? > > As I understand the issue, the main reason is that event triggers > execute procedures, and those exist in a single database only. If you > were to create an event trigger in database A, then a user gets created > in database B, your function would not be invoked, which becomes a > problem.
Yeah... You'd need something at the C level as a hook because you can't rely on pg_proc etc. For BDR I've been thinking of optionally replicating such actions using a ProcessUtility_hook and deparse or simply verbatim sql capture. Then replicating via generic logical wal messages.