[Bucardo-general] Bucardo and Selective row sync in Master / Master mode

A. David david.arakelian at gmail.com
Fri Sep 13 16:19:59 UTC 2013


Hello David,

Thanks for the hint of bucardo add customcols,

I think I am misunderstanding the concept, in your example it will still
sync the data but with different values wouldn't it ? What I am trying to
do is simply ignore a ROW if it meets certain criteria. Is this possible?

Thank you!




On Fri, Sep 13, 2013 at 5:02 PM, David E. Wheeler <david at justatheory.com>wrote:

>
> On Sep 13, 2013, at 8:33 AM, A. David <david.arakelian at gmail.com> wrote:
>
> > Remove the customselect parameter. Use the customcols command, instead.
> >     [David Wheeler]
> >
> > Will this allow to have a "WHERE clause" or it will only allow me to do
> "column1, columnN..."
>
> I believe just the latter, but you can use expressions:
>
>     bucardo add customcols public.foobar "select a, upper(b) AS b, CASE c
> WHEN FALSE THEN 0 ELSE 1 END" AS c db=foo
>
> Best,
>
> David
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20130913/d01ca42b/attachment.html>


More information about the Bucardo-general mailing list