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