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

[cka at f4-group.com]

Great ! Thanks a lot :)

I could not get the patch to work, so I'll try it out at release :)

Le 13/07/2023 à 04:39, Tatsuo Ishii a écrit :
>>> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general