[Bucardo-general] Which version to run and multi-column primary keys support
Constantine Domashnev
dconst at rec.ri.cmu.edu
Thu Feb 26 19:41:22 UTC 2009
Thank you very much for the tips.
Constantine
ps. Chapter "Populating Bucardo" on http://bucardo.org/bucardo.html
implies that the Bucardo DB may be populated by hands, which to some may
look like a good exercise and an alternative to using test examples.
> 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
>
>
More information about the Bucardo-general
mailing list