Re: Protocol question regarding Portal vs Cursor

Поиск
Список
Период
Сортировка
От Dave Cramer
Тема Re: Protocol question regarding Portal vs Cursor
Дата
Msg-id CADK3HH+2iaGWV+UCW3B6jwygH5zg5spgXqBebd1vzKAU4S1ucw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Protocol question regarding Portal vs Cursor  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Protocol question regarding Portal vs Cursor
Список pgsql-hackers


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

Dave

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ilya Gladyshev
Дата:
Сообщение: Re: REINDEX not updating partition progress
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Recent 027_streaming_regress.pl hangs