[pgpool-general: 5164] Re: Cause reads inside transaction go to master

[Tatsuo Ishii]

> Hi Experts,
> 
> I understand that reads inside a transaction that follow one or more write statement will go to the master node.
> I would like to know if this is also true that the reads inside a transaction will go to master if
> 
> 1)      they follow a read statement with /*nobalance*/ comment?

No.

> 2)      They follow a read statement from a system table?

No.

> If the above two cases will not cause the reads that follow them in the transaction to go to master will any other type of read would or I just need to have  only a write statement to cause it.

Only a write statement.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp