Re: [HACKERS] Database replication... - Mission Critica

"Mikheev, Vadim" <VMIKHEEV(at)sectordata(dot)com> writes:
> > My presumption would be that if you initialize 2 databases to
> > a known identical start, have all the same triggers and rules
> > on both, then send all queries to both databases, you will
> > have 2 identical databases at the end.
>
> This is wrong assumption.

Agreed. Another simple example is:

INSERT INTO foo VALUES (random());

Cheers,

Neil

--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC