On Thu, 2002-11-07 at 19:36, Christopher Kings-Lynne wrote:
> Even nastier, what about if the different postgres servers in the cluster
> run on different architectures! That way you'd get different floating point
> results on each machine...
Oh come on! There's no such thing as "perfect" anywh
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
> Also, what about if the two servers get the 'begin' command at marginally
> different times, then even:
>
> INSERT INTO foo VALUES (CURRENT_TIMESTAMP);
>
> Will be different on each different machine.
Yeah -- and gettimeofday() will be inco
> "Mikheev, Vadim" <[EMAIL PROTECTED]> 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. If
> >
> > 1st client executes UPDATE t SET a = 1 WHERE b = 2;
> > 2nd client executes UPDATE t SET a = 2 WHERE b = 2;
> >
> > at "the same time" you don't know in what order these
> > queries will be executed on two different servers (because
> > you can't control
On 4 Nov 2002 at 12:23, Mikheev, Vadim wrote:
> > 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
"Mikheev, Vadim" <[EMAIL PROTECTED]> 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 wr
> 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. If
1st client executes UPDATE t SET a =
