pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  
help / color / mirror / Atom feed
From: vlsi (@vlsi) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: [pgjdbc/pgjdbc] PR #3678: fix: unable to open replication connection to servers < 12
Date: Mon, 16 Jun 2025 07:29:25 +0000
Message-ID: <[email protected]> (raw)

pgjdbc attempted issuing SET extra_float_digits for servers of versions less than 12, while the replication protocol does not allow set ... commands.

It resulted in the following [connection failure](https://github.com/pgjdbc/pgjdbc/actions/runs/15672177908/job/44145122287?pr=3668#step:8:991):

    org.postgresql.util.PSQLException: ERROR: syntax error
        at app//org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2736)
        at app//org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2421)
        at app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:372)
        at app//org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:330)
        at app//org.postgresql.core.SetupQueryRunner.run(SetupQueryRunner.java:57)
        at app//org.postgresql.core.v3.ConnectionFactoryImpl.runInitialQueries(ConnectionFactoryImpl.java:1031)
        at app//org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:358)
        at app//org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:57)
        at app//org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:277)
        at app//org.postgresql.Driver.makeConnection(Driver.java:448)
        at app//org.postgresql.Driver.connect(Driver.java:298)
        at platform/[email protected]/java.sql.DriverManager.getConnection(DriverManager.java:683)
        at platform/[email protected]/java.sql.DriverManager.getConnection(DriverManager.java:191)
        at app//org.postgresql.test.TestUtil.openDB(TestUtil.java:356)
        at app//org.postgresql.test.TestUtil.openReplicationConnection(TestUtil.java:338)
        at app//org.postgresql.replication.CopyBothResponseTest.setUp(CopyBothResponseTest.java:60)


view thread (2+ 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] PR #3678: fix: unable to open replication connection to servers < 12
  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