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 folding2024-07-25 15:55:39 FINEST org.postgresql.core.v3.QueryExecutorImpl receiveErrorResponse <=BE ErrorMessage(ERROR: portal "C_3" does not existAs 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 по дате отправления: