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

Reply via email to