[Pgcluster-general] Table requirements
Gábriel Ákos
akos.gabriel at i-logic.hu
Thu May 17 16:22:40 UTC 2007
Hi,
I'd like (for documentational purposes) have an exact statement about
what a table has to look like to be replicated properly by pgcluster?
As far as I learned some kind of unique key has to be there.
Can this be a simple "composite key" of - say - the columns of the
table? For example I have a table with 2 string columns (name, role).
This is not replicated correctly by default. As far as I learned by
generating a composite key (name+role) it won't work either. By adding
an (otherwise meaningless) unique id, generated by a sequence, the
table will be replicated correctly.
Thanks for your help!
--
Üdvözlettel,
Gábriel Ákos
-=E-Mail :akos.gabriel at i-logic.hu|Web: http://www.i-logic.hu =-
-=Tel/fax:+3612367353 |Mobil:+36209278894 =-
More information about the Pgcluster-general
mailing list