On Thu, 25 Jul 2024 at 16:19, David G. Johnston <david.g.johns...@gmail.com> wrote:
> On Thursday, July 25, 2024, Dave Cramer <davecra...@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 >
