[Bucardo-general] Bucardo and junction tables

Armin Resch reschab at gmail.com
Thu Jul 9 10:01:05 UTC 2015

 The former because (1) it's the better schema design, and (2) Bucardo
reads the PK automagically when you mark the table for replication, iirc.

On Thu, Jul 9, 2015 at 10:31 AM, Federico Fanton <federico at panizzolo.it>

> I see, should I add the composite PK definition to the database itself, or
> is there a way to tell Bucardo "use these columns as PK"?
> On 09/07/2015 10:08, Armin Resch wrote:
>> Junction tables' primary key is typically the combination of the foreign
>> key columns to the entity tables' primary keys which they join.
>> Cheers,
>> -ar
>> On Thu, Jul 9, 2015 at 9:45 AM, Federico Fanton <federico at panizzolo.it
>> <mailto:federico at panizzolo.it>> wrote:
>>     Hi everyone!
>>     What is the recommended way to handle junction tables with Bucardo,
>>     since they don't have primary keys? (I'm setting up an "autokick"
>>     sync, if it's relevant)
>>     _______________________________________________
>>     Bucardo-general mailing list
>>     Bucardo-general at bucardo.org <mailto: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/20150709/50a63213/attachment-0001.html>

More information about the Bucardo-general mailing list