[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