[Bucardo-general] Re bucardo * ALWAYS triggers
Greg Sabino Mullane
greg at endpoint.com
Mon Aug 4 15:30:43 UTC 2014
On Sat, Aug 02, 2014 at 10:15:59AM -0400, Jonathan Brinkman wrote:
> Thank you for explanations!
>
> Re ALWAYS triggers, I have an AFTER trigger on some tables that writes an
> audit-trail record to a change_log table. That only happens in the "Main"
> database. But if a data modification happens in the "Child" database, which
> is also a Source/Master DB, then the Main DB doesn't want to fire that
> audit-trail trigger (upon bucardo replication) unless I make the audit-trail
> trigger an ALWAYS trigger.
>
> Am I doing it wrong?
Nope, that is the perfect use case for setting a trigger to ALWAYS. :)
--
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20140804/d9ea05b5/attachment.sig>
More information about the Bucardo-general
mailing list