[Pgcluster-general] Table requirements

Zoff zoff at zoff.cc
Thu May 17 18:29:39 UTC 2007


Hi!

thats simply not true!
pgcluster replicates all kind of tables. everything else would just be useless.

	cheers,
	Zoff.

Gábriel Ákos wrote:
> 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!
> 



More information about the Pgcluster-general mailing list