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

[Jonathan Brinkman]

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