On Thu, 25 Jul 2024 at 17:52, Dave Cramer <davecra...@gmail.com> wrote:
> > > 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 > > So while the API's are "virtually" identical AFAICT there is no way to create a "WITH HOLD" portal ? Dave >
