Alan Acosta wrote:
> So, why i need to use Slony,or better, when i want to use it ? and Are
> the random values the most important issue ?, Nobody know why
> PGCluster doesn't replicate correctly ?
Random values merely represent the easiest example to describe.

Query-propagating systems are susceptible to data corruption for any
update that involves either a nondeterministic query, a time-sensitive
query, or host-sensitive results.

It is completely obvious that RANDOM() provides results that are only
replicable at the same time on the same host.

It is completely obvious that NOW() is sensitive to when it is run.

In addition, any query of the following form will corrupt the
consistency between nodes:

   insert into t1 (select * from t2 limit 10);

The only way that query *could* be replicable would be if it declared an
ordering on t2 that could guarantee that, on two hosts, you'd get the
same result set.  E.g. -

   insert into t1 (select * from t2 order by [columns representing
candidate primary key] limit 10);