Postgres Pro
Downloads
Home   >   mailing lists

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

From Dave Cramer
Subject Re: Protocol question regarding Portal vs Cursor
Date
Msg-id CADK3HHJ1auYQHoWv4ZJxFUpX=TFsK1yVj3V406RwyR2U8nRvbw@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 Thu, 25 Jul 2024 at 17:52, Dave Cramer <davecramer@gmail.com> wrote:


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


So while the API's are "virtually" identical AFAICT there is no way to create a "WITH HOLD" portal ?

Dave

pgsql-hackers by date:

Previous
From: "Andrey M. Borodin"
Date:
Subject: Re: WIP: parallel GiST index builds
Next
From: Shubham Khanna
Date:
Subject: Re: Pgoutput not capturing the generated columns