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