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

[Tatsuo Ishii]

Sure we can add to the TODO list.

If the item has enough interest from many users, the possibility to
implement it will be getting higher.

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

> Hi all,
> 
> Thanks for the reply.
> 
> Can we make it configurable and have a key in pgpool.cof to indicate which string in the comment indicates that it should go to master.  If the key is empty it will mean all comments.  This way we can be backward compatible, but can still use it with Hibernate.  Can it be added?
> 
> Thanks
> Avi
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Wednesday, January 04, 2017 4:55 AM
> To: Avi Weinberg <AviW at gilat.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 5209] forcing select to go to master with /*nobalance*/
> 
>> 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
> IMPORTANT - This email and any attachments is intended for the above named addressee(s), and may contain information which is confidential or privileged. If you are not the intended recipient, please inform the sender immediately and delete this email: you should not copy or use this e-mail for any purpose nor disclose its contents to any person.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general