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

[Tatsuo Ishii]

Than you for testing. The patch will appear in the next minor releases.

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

> Thank you,
> I have been able to validate that this fixes the known cases I had lined up.
> (I have not been able to validate a full production django deployment
> since I can't really deploy a patched pgpool as things stand).
> 
> Thanks,
> Heather
> 
> On Thu, Sep 28, 2023 at 7:00 PM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>>
>> >> 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
> 
> -- 
>  
> <https://opendrives.ac-page.com/nabny2023?utm_source=OD&utm_medium=AC&utm_campaign=nabny23>
> Need a free guest pass? Use code: *NY8238*
>