Hi, Thanks to both of you, the "enable always trigger" solved my problem.
Csaba On 24 February 2013 16:37, Jonathan Brinkman <[email protected]> wrote: > -- ENABLE ALWAYS all double-hopping triggers > ALTER TABLE idsystem.mytablename ENABLE ALWAYS TRIGGER > trupdate_my_trigger_name; > > -----Original Message----- > From: [email protected] > [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Sunday, February 24, 2013 7:00 AM > To: [email protected] > Subject: Bucardo-general Digest, Vol 65, Issue 16 > > Send Bucardo-general mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > To: Csaba Simon <[email protected]> > Cc: [email protected] > Subject: Re: [Bucardo-general] Custom triggers are not fired on remote > database tables > Message-ID: <[email protected]> > 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 [email protected] > 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 <[email protected]> > To: Mitchell Perilstein <[email protected]> > Cc: [email protected] > Subject: Re: [Bucardo-general] table name case sensitivity > Message-ID: <[email protected]> > 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 [email protected] > 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 <[email protected]> > To: Greg Sabino Mullane <[email protected]> > Cc: [email protected] > Subject: Re: [Bucardo-general] Custom triggers are not fired on remote > database tables > Message-ID: > < > caeusehqam8p88dawrrddziocwgvtvdgekp+hasjisbsy40w...@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 <[email protected]> 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 [email protected] > > 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 > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general > > > End of Bucardo-general Digest, Vol 65, Issue 16 > *********************************************** > > _______________________________________________ > Bucardo-general mailing list > [email protected] > https://mail.endcrypt.com/mailman/listinfo/bucardo-general >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
