[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