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

[Jerry Richards]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20120217/bb1e88df/attachment-0001.html