[Pgpool-general] Inconsistent execution sequence

[Qian Xu]

Am Dienstag, den 14.04.2009, 07:05 +0900 schrieb Tatsuo Ishii:
> > BTW: Do you mean, that pgpool will guarantee a consistent execution
> > sequence, even when they come from different db-connections?
> 
> Yes.
> 
> > I mean: I have two db-connections (dbconn1, dbconn2). If there is only
> > one database. The sequence will be:
> > 1. dbconn1: begin;
> > 2. dbconn2: begin;
> > 3. dbconn1: update ...;
> > 4. dbconn2: update ...;
> > 5. dbconn1: end;
> > 6. dbconn2: end;
> > 
> > Do you mean, pgpool will guarantee that database1 (master) and database2
> > (slave2) will have exactly the same execution sequence?
> > 

Hi All again.

If I set "replication_strict = true" in pgpool.conf or put "/*STRICT*/"
at the beginning of each statement, the execution sequence will be
guaranteed to be consistent as well, won't it?


Best regards
--Qian