| From: | Dave Cramer <davecramer(at)gmail(dot)com> |
|---|---|
| To: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Protocol question regarding Portal vs Cursor |
| Date: | 2024-07-25 21:52:41 |
| Message-ID: | CADK3HH+2iaGWV+UCW3B6jwygH5zg5spgXqBebd1vzKAU4S1ucw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
Dave
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2024-07-25 22:10:29 | Re: Recent 027_streaming_regress.pl hangs |
| Previous Message | Ilya Gladyshev | 2024-07-25 21:21:49 | Re: REINDEX not updating partition progress |