Re: The same prepared query yield "-1" the first six times and then "-1.0"

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: Edoardo Panfili <edoardo(dot)panfili(at)iisgubbio(dot)edu(dot)it>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: The same prepared query yield "-1" the first six times and then "-1.0"
Date: 2023-08-21 18:00:23
Message-ID: CAFj8pRCCqC9iq959iNGYM1_nFedBq-OP6Lr5MT3MwKL6jovWJQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

po 21. 8. 2023 v 19:52 odesílatel Edoardo Panfili <
edoardo(dot)panfili(at)iisgubbio(dot)edu(dot)it> napsal:

>
>
> > Il giorno 21 ago 2023, alle ore 18:45, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> ha
> scritto:
> >
> > "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> >> Otherwise, I agree this seems like a bug, probably in the JDBC driver,
> >> though one pertains to style as opposed to semantics since both answers
> are
> >> technically correct.
> >
> > I don't see any such behavior change in psql, so I agree that this is
> > probably something to ask about on the JDBC list.
>
> I’m going to ask there, thank you
>

Maybe it is switch from client side prepared statements to server side
prepared statements

see *prepareThreshold *https://jdbc.postgresql.org/documentation/use/

I don't use Java, so I don't know more

Regards

Pavel

> Edoardo
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2023-08-21 18:04:15 Re: The same prepared query yield "-1" the first six times and then "-1.0"
Previous Message Edoardo Panfili 2023-08-21 17:24:03 Re: The same prepared query yield "-1" the first six times and then "-1.0"