[Bucardo-general] bucardo serial field replication.

Itamar Reis Peixoto itamar at ispbrasil.com.br
Thu Jan 29 13:11:22 UTC 2009


I have a master-master replication (SWAP)

db1 - machine1
customers (id serial, name(varchar(50))

db1 - machine2
customers (id serial, name(varchar(50))

insert into db1.customers (name) values ("Itamar")

insert into db2.customers (name) values ("Greg")

after inserting "Greg" in db2 it's get the id=1 and overwrite the name
"Itamar" because sequence is not replicated


any suggestion about how to deal with this ?


------------

Itamar Reis Peixoto

e-mail/msn: itamar at ispbrasil.com.br
sip: itamar at ispbrasil.com.br
skype: itamarjp
icq: 81053601
+55 11 4063 5033
+55 34 3221 8599



More information about the Bucardo-general mailing list