Re: Protocol question regarding Portal vs Cursor

On Thu, 25 Jul 2024 at 16:19, David G. Johnston <david.g.johnston@gmail.com> wrote:

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

 

You would be absolutely correct! Thanks for the quick response