[Bucardo-general] Which version to run and multi-column primary keys support

Greg Sabino Mullane greg at endpoint.com
Thu Feb 26 18:57:29 UTC 2009

Constantine Domashnev wrote:
> In V3.2.7, what would be the correct syntax [pkey, pkeytype] to create a
> goat entry for a MCPK table?

You shouldn't need to specify those yourself: Bucardo will figure them
out for you. But in case you do, it's just a pipe-separated list of
items. For example, here's the goat table as populated by the testing suite:

id                 | 9
db                 | A
schemaname         | public
tablename          | bucardo_test_multicol
reltype            | table
pkey               | id|id2|id3
qpkey              | id|id2|id3
pkeytype           | int4|int4|int4
has_delta          | f
ping               | \N
customselect       | \N
makedelta          | \N
rebuild_index      | \N
ghost              | f
standard_conflict  | \N
analyze_after_copy | t
strict_checking    | t
cdate              | 2009-02-26 13:55:37.534429-05

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: 226 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20090226/2e29bbb5/attachment.bin 

More information about the Bucardo-general mailing list