[Pgpool-general] Inconsistent execution sequence

[Tatsuo Ishii]

> Am Freitag, den 10.04.2009, 11:57 +0900 schrieb Tatsuo Ishii:
> > Which version of pgpool is this?
> > --
> 
> I am using pgpool I (3.31)

I recommend to use pgpool-II. We are focusing on pgpool-II.

> I have a python script (module pg is required), which can reprocedure
> this problem. If someone want a test script, please mail me.

Please try it with pgpool-II. If you still have the problem, please
let me know.

> It is just a generic question. I would like to know, if PgPool will
> guarantee a consistent execution sequence on different database
> backends. If it will, could you tell me more specifically. 
> 
> Inconsistent execution sequence can easily produce dead lock.

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.
--
Tatsuo Ishii
SRA OSS, Inc. Japan