| 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: | Raw Message | Whole Thread | 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
>
>
>
>
| 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" |