Re: Protocol question regarding Portal vs Cursor

On Thu, 25 Jul 2024 at 17:52, Dave Cramer <davecramer(at)gmail(dot)com> wrote:

>
>
> On Thu, 25 Jul 2024 at 16:19, David G. Johnston <
> david(dot)g(dot)johnston(at)gmail(dot)com> wrote:
>
>> On Thursday, July 25, 2024, Dave Cramer <davecramer(at)gmail(dot)com> wrote:
>>
>> May not make a difference but…
>>
>>
>>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
>>> sendSimpleQuery FE=> SimpleQuery(query="declare C_3 CURSOR WITHOUT HOLD
>>> FOR SELECT * FROM testsps WHERE id = 2")
>>>
>>
>> You named the cursor c_3 (lowercase due to SQL case folding)
>>
>>
>>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
>>> sendDescribePortal FE=> Describe(portal=C_3)
>>>
>>
>> The protocol doesn’t do case folding
>>
>>
>>>
>>> 2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl
>>> receiveErrorResponse <=BE ErrorMessage(ERROR: portal "C_3" does not exist
>>>
>>
>> As evidenced by this error message.
>>
>> Location: File: postgres.c, Routine: exec_describe_portal_message,
>>> Line: 2708
>>>
>>>
>>
>> You would be absolutely correct! Thanks for the quick response
>
>
So while the API's are "virtually" identical AFAICT there is no way to
create a "WITH HOLD" portal ?

Dave

>