pgjdbc/pgjdbc GitHub issues and pull requests (mirror)
help / color / mirror / Atom feedFrom: NKame (@NKame) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] issue #3432: Don't send extra_float_digits for PostgreSQL 12+ by default
Date: Thu, 07 Nov 2024 11:34:21 +0000
Message-ID: <[email protected]> (raw)
**Describe the issue**
Connecting through PgBouncer with a default configuration fails.
**Driver Version?**
All supported.
**Java Version?**
All supported.
**OS Version?**
All supported.
**PostgreSQL Version?**
>= 12
**To Reproduce**
Connect throught PgBouncer. Fails with unsupported extra_float_digits parameter.
**Expected behaviour**
Connected to the database.
**Context**
extra_float_digits has been introduced in PostgreSQL 8.4 to play around the apparent precision of the lossy datatype "float". At first to increase the precision sent to the client, then since version 12, to reduce it. In pgJDBC, if you want the "full" precision with a server 12+, you must override this parameter since it is forced in the driver to the value 3 if the server is 9+, that means you have to send it twice to the server. Furthermore, by default it's not authorized by default with PgBouncer: "the internet" answer is to change the server, whereas it doesn't make really sense to send it at all for PostgreSQL 12+. (And the question of forcing a default for the lossy datatype should be asked... in my view it should be an explicit choice from the application owner).
view thread (6+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: github://pgjdbc/pgjdbc
Cc: [email protected], [email protected]
Subject: Re: [pgjdbc/pgjdbc] issue #3432: Don't send extra_float_digits for PostgreSQL 12+ by default
In-Reply-To: <<[email protected]>>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox