[Pgpool-general] Inconsistent execution sequence

[Tatsuo Ishii]

> Am Samstag, den 11.04.2009, 08:51 +0900 schrieb Tatsuo Ishii:
> > Yes pgpool-II is deigned to guarantee a consistent execution
> > sequence. It sends a query to the first node then wait it's response
> > before sending a query to the second node.
> 
> Hi Tatsuo,
> 
> if you have installed python, could you please run this script to verify
> my problem? (I have no free server to install pgpool-II right now)

I have no time to try the script right now. Sorry. I would appreciate
if someone try your script instead me.

> 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?
> 
> Best regards
> --Qian