[pgpool-general: 5212] Re: forcing select to go to master with /*nobalance*/

[Tatsuo Ishii]

> Hi all,
> 
> I'm using hibernate and wanted to use /*nobalance*/ to force some
> selects to go to master.  However, when I enabled hibernate to pass
> comments to the database it added its own comments to each and every
> query.  As a result all my selects go to master.  It seems like
> pgpool does not care what the comment is as long as there is a
> comment it sends it to master.

Yes, currently Pgpool-II does not care about the actual contents of the comment.

> How can I tell pgpool to send it to the master only if the comment is /*nobalance*/

Sorry there's no way to do that.

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