Thanks Greg, have a nice day, Regards, Hiram
Saludos cordiales, Hiram Walker O. +56965824408 2017-12-12 18:39 GMT-03:00 Greg Sabino Mullane <[email protected]>: > Sory, been to busy to reply but I can do this one super quick: > > > ERROR: duplicated key > .. > > How can I tell bucardo that I have a column With Autoincrement value? > > You cannot. The canonical solution is to adjust the sequences on both > ends such that they cannot collide. > > Server A: ALTER SEQUENCE foo_id_seq RESTART WITH 10000 INCREMENT BY 2; > > Server B: ALTER SEQUENCE foo_id_seq RESTART WITH 10001 INCREMENT BY 2; > > -- > Greg Sabino Mullane [email protected] > End Point Corporation > PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 >
_______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
