[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