[Bucardo-general] Bucardo and junction tables

[Armin Resch]

 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.
-ar

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

> 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>