> 3) We defined tentative primary keys for the bucardo's tables: > bucardo.bucardo_delta_names > bucardo.bucardo_delta_targets > bucardo.bucardo_sequences > bucardo.bucardo_truncate_trigger > bucardo.bucardo_truncate_trigger_log
There are unique constraints for some of these which could be turned into PKs instead; - bucardo_delta_names (sync, tablename) - bucardo_delta_targets (tablename, target) (technically not unique, but could probably be so) - bucardo_sequences (schemaname, seqname, syncname, targetname) - bucardo_truncate_trigger (sync, tablename) (not unique, but could probably be so) - bucardo_truncate_trigger_log (tablename, sname, tname, sync, target) (not unique but could probably be so) I can’t guarantee that this will definitely work with the above, but I would expect that it should probably work. :) HTH, David -- David Christensen End Point Corporation [email protected] 785-727-1171
signature.asc
Description: Message signed with OpenPGP
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
