[Bucardo-general] Custom triggers are not fired on remote database tables

Sun Feb 24 20:41:51 UTC 2013

Hi,

Thanks to both of you, the "enable always trigger" solved my problem.

Csaba

On 24 February 2013 16:37, Jonathan Brinkman <jb at blackskytech.com> wrote:

> -- ENABLE ALWAYS all double-hopping triggers
> ALTER TABLE idsystem.mytablename ENABLE ALWAYS TRIGGER
> trupdate_my_trigger_name;
>
> -----Original Message-----
> From: bucardo-general-bounces at bucardo.org
> [mailto:bucardo-general-bounces at bucardo.org] On Behalf Of
> bucardo-general-request at bucardo.org
> Sent: Sunday, February 24, 2013 7:00 AM
> To: bucardo-general at bucardo.org
> Subject: Bucardo-general Digest, Vol 65, Issue 16
>
> Send Bucardo-general mailing list submissions to
>         bucardo-general at bucardo.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
>         https://mail.endcrypt.com/mailman/listinfo/bucardo-general
> or, via email, send a message with subject or body 'help' to
>         bucardo-general-request at bucardo.org
>
> You can reach the person managing the list at
>         bucardo-general-owner at bucardo.org
>
> When replying, please edit your Subject line so it is more specific than
> "Re: Contents of Bucardo-general digest..."
>
>
> Today's Topics:
>
>    1. Re: Custom triggers are not fired on remote database tables
>       (Greg Sabino Mullane)
>    2. Re: table name case sensitivity (Greg Sabino Mullane)
>    3. Re: Custom triggers are not fired on remote database tables
>       (Csaba Simon)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Sat, 23 Feb 2013 23:45:05 -0500
> From: Greg Sabino Mullane <greg at endpoint.com>
> To: Csaba Simon <simocsab at gmail.com>
> Cc: bucardo-general at bucardo.org
> Subject: Re: [Bucardo-general] Custom triggers are not fired on remote
>         database tables
> Message-ID: <20130224044504.GE2315 at broken.home>
> Content-Type: text/plain; charset="us-ascii"
>
> On Thu, Feb 21, 2013 at 02:58:50PM +0100, Csaba Simon wrote:
> > Should I use customcode feature instead of triggers on remote side?
> > How can I configure it?
> ...
> > > I would like to use custom triggers on some of the remote database
> > > tables but these triggers does not work when rows are updated by
> Bucardo.
>
> It's not clear what you are trying to do. If you have triggers that you
> wrote that you need to fire on the remote database, mark them as 'always'
> to
> have them fire no matter what, or as 'replica', to have them fire only when
> Bucardo makes changes.
>
>
> --
> 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/20130223/43
> 02b604/attachment-0001.sig>
>
> ------------------------------
>
> Message: 2
> Date: Sun, 24 Feb 2013 00:00:26 -0500
> From: Greg Sabino Mullane <greg at endpoint.com>
> To: Mitchell Perilstein <Mitchell.Perilstein at trueposition.com>
> Cc: bucardo-general at bucardo.org
> Subject: Re: [Bucardo-general] table name case sensitivity
> Message-ID: <20130224050026.GF2315 at broken.home>
> Content-Type: text/plain; charset="us-ascii"
>
> On Thu, Feb 21, 2013 at 10:45:09AM -0500, Mitchell Perilstein wrote:
> ...
> > My database downcases any table names you give it when reporting them
> > back.  (Other DB's upcase them by the way!) This can lead to issues if
> > you don't give Bucardo names in the same
> > case as reported.   Eg, make a table:
>
> I'm not convinced this is an issue. Bucardo looks for the exact case you
> give it; the fact that Postgres downcases unquoted identifiers is not
> really
> relevant to that. We would still want, for example, for ./bucardo add table
> FooBar to pick up the table FooBar but not foobar or FOOBAR.
>
> --
> 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/20130224/71
> ffad0c/attachment-0001.sig>
>
> ------------------------------
>
> Message: 3
> Date: Sun, 24 Feb 2013 08:15:16 +0100
> From: Csaba Simon <simocsab at gmail.com>
> To: Greg Sabino Mullane <greg at endpoint.com>
> Cc: bucardo-general at bucardo.org
> Subject: Re: [Bucardo-general] Custom triggers are not fired on remote
>         database tables
> Message-ID:
>         <
> CAEUSEhQAm8P88dAwrrDdzioCWgVTVdGEKp+hAsJiSbSy40Wk8w at mail.gmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
>
> My case is 'replica', I would like have fired my custom triggers on remote
> tables when these tables are updated by Bucardo.
>
> Csaba
>
> On 24 February 2013 05:45, Greg Sabino Mullane <greg at endpoint.com> wrote:
>
> > On Thu, Feb 21, 2013 at 02:58:50PM +0100, Csaba Simon wrote:
> > > Should I use customcode feature instead of triggers on remote side?
> > > How
> > can
> > > I configure it?
> > ...
> > > > I would like to use custom triggers on some of the remote database
> > tables
> > > > but these triggers does not work when rows are updated by Bucardo.
> >
> > It's not clear what you are trying to do. If you have triggers that
> > you wrote that you need to fire on the remote database, mark them as
> > 'always' to have them fire no matter what, or as 'replica', to have
> > them fire only when Bucardo makes changes.
> >
> >
> > --
> > Greg Sabino Mullane greg at endpoint.com
> > End Point Corporation
> > PGP Key: 0x14964AC8
> >
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> <
> https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130224/06
> 0022e3/attachment-0001.html>
>
> ------------------------------
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
> End of Bucardo-general Digest, Vol 65, Issue 16
> ***********************************************
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130224/6b19463a/attachment-0001.html>