[Bucardo-general] Error When Adding Sync swap (or pushdelta)

[Frank NJ.]

And how do you add this primary key to your sync table please?

Sorry if my question sounds very basic...

Thanks,
Frank

On 17 February 2012 22:56, Jerry Richards <jerry.richards at teotech.com>wrote:

> Apparenty, I added the PRIMARY KEY to my sync table after I installed
> bucardo_ctl.  I got it working by dropping the bucardo database and then
> re-executing "bucardo_ctl install" again and re-executing the commands.***
> *
>
> ** **
>
> So this issue is closed.****
>
> ** **
>
> Thanks,****
>
> Jerry****
>
> ** **
>
> *From:* Jerry Richards
> *Sent:* Friday, February 17, 2012 12:46 PM
> *To:* 'bucardo-general at bucardo.org'
> *Subject:* Error When Adding Sync swap (or pushdelta)****
>
> ** **
>
> I'm getting an error adding a sync.  It says I must specify a primary
> key.  There is only one table in the herd and it does have a primary key of
> varchar(255).  Is this error saying I must specify the primary key in the
> command line?  If so, what is that parameter?****
>
> ** **
>
> COMMAND:****
>
> bucardo_ctl add sync fs_calls_sync type=swap source=fs_calls_herd
> targetdb=multisrv_c57_teo****
>
> ** **
>
> ERROR:****
>
> CONTEXT:  SQL statement "SELECT validate_sync('fs_calls_sync')"****
>
> Failed to add sync: DBD::Pg::st execute failed: ERROR:  error from Perl
> function "validate_sync": error from Perl function "validate_sync": Table
> "ts_core.calls" must specify a primary key when using a sync of 'swap' at
> line 263. at line 30. at /usr/bin/bucardo_ctl line 3362.****
>
> ** **
>
> Thanks,****
>
> Jerry****
>
> _______________________________________________
> Bucardo-general mailing list
> Bucardo-general at bucardo.org
> https://mail.endcrypt.com/mailman/listinfo/bucardo-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120316/33219bfb/attachment.html