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

[Charly Koza]

Thanks a lot :)

Le 10/07/2023 à 12:01, Tatsuo Ishii a écrit :
>> I have no idea what that is, I thought it was added by pgpool :D
>>
>>  From osm2pgsql source
>> https://github.com/openstreetmap/osm2pgsql/blob/60e3e5c1b05b31c66e725c2737b3adc69d869ba5/src/middle-pgsql.cpp#L1423
>>
>> Both mark_rels_by_node and mark_rels_by_way prepared statements are in
>> the same string, so probably sent as a single query.
> 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.
>
> Best reagards,
> --
> Tatsuo Ishii
> SRA OSS LLC
> English: http://www.sraoss.co.jp/index_en/
> Japanese:http://www.sraoss.co.jp
>