[pgpool-general: 8938] Re: Server-side cursors using Declare/Describe do not work in pgpool-ii

[Tatsuo Ishii]

>> I'd think that fixing this would either involve tracking DECLARE
>> statements like other portal statements, or passing the message to the
>> primary to let it handle the Describe on its own.
> 
> The latter looks simple but I need to investigate more.

I have created a patch in this direction.

The former needs not only tracking DECLARE at Parse phase, but needs
to track the portal removal when a transaction commit depending on WITH
HOLD option. I decide that the complexity is not worth the problem.

>> Let me know if there is anything I can do to help!

Can you please try out the attached patch?

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: v1-0001-Fix-Describe-so-that-it-does-not-abort-with-porta.patch
Type: text/x-patch
Size: 3327 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20230929/ea296116/attachment.bin>