Postgres Pro
Downloads
Home   >   mailing lists

Re: Protocol question regarding Portal vs Cursor - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Protocol question regarding Portal vs Cursor
Date
Msg-id CAKFQuwY9MchqV_OQyfj1s4g5dvA+0A+OAh-9LAgG-xG0-ZpcAQ@mail.gmail.com
Whole thread Raw
In response to Re: Protocol question regarding Portal vs Cursor  (Dave Cramer <davecramer@gmail.com>)
Responses Re: Protocol question regarding Portal vs Cursor
List pgsql-hackers
Tree view
On Thursday, July 25, 2024, Dave Cramer <davecramer@gmail.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.

 

pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Protocol question regarding Portal vs Cursor
Next
From: Jeff Davis
Date:
Subject: [18] separate collation and ctype versions, and cleanup of pg_database locale fields