Re: Protocol question regarding Portal vs Cursor

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Protocol question regarding Portal vs Cursor
Дата
Msg-id CADK3HHJ1auYQHoWv4ZJxFUpX=TFsK1yVj3V406RwyR2U8nRvbw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Protocol question regarding Portal vs Cursor  (Dave Cramer <davecramer@gmail.com>)
Список pgsql-hackers


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 по дате отправления:

Предыдущее
От: "Andrey M. Borodin"
Дата:
Сообщение: Re: WIP: parallel GiST index builds
Следующее
От: Shubham Khanna
Дата:
Сообщение: Re: Pgoutput not capturing the generated columns