[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