[pgpool-general: 8893] Re: Prepared statements over pgpool ?

[Tatsuo Ishii]

>> I see. That's the problem. Pgpool-II cannot handle queries on a single
>> line well (we call it "multi statement query"). In this case only
>> "PREPARE mark_rels_by_node..." is recognized by Pgpool-II but "PREPARE
>> mark_rels_by_way..." is not.  Currently there's no workaround for
>> this.
> 
> After more thought I come up with attached patch. In the patch pgpool
> check each parse tree (corresponding ro each PREPARE statement in this
> case), and memorize the prepared statement names for later bind
> message. It works at least for me.

I have pushed the patch to from master to 4.1 stable.

https://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=0d54c68d5cfba549e5b6fb7d3247d66ee50ab1d9

Will appear in the next minor releases (scheduled Aug 17th).

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp