| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Dave Cramer <davecramer(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 20:19:03 |
| Message-ID: | CAKFQuwY9MchqV_OQyfj1s4g5dvA+0A+OAh-9LAgG-xG0-ZpcAQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
>
>
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2024-07-25 20:29:08 | [18] separate collation and ctype versions, and cleanup of pg_database locale fields |
| Previous Message | Dave Cramer | 2024-07-25 20:14:24 | Re: Protocol question regarding Portal vs Cursor |