pgjdbc/pgjdbc GitHub issues and pull requests (mirror)  

help / color / mirror / Atom feed

From: papegaaij (@papegaaij) <[email protected]>
To: pgjdbc/pgjdbc <[email protected]>
Subject: Re: [pgjdbc/pgjdbc] issue #3724: Regression: FATAL:  simple query "BEGIN" arrived before ending an extended query message
Date: Wed, 09 Jul 2025 12:48:37 +0000
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

I totally get the issue with limited time, especially on open source projects like this and I really do not judge the decisions made. I think the PostgreSQL community is great, responsive, open minded and very helpful in many cases. See it from the positive side: the discussion-like ticket has now become a user-facing issue, so it will probably attract some more attention 😄 

The problem is that at the moment pgpool-II users are a bit stuck between a rock and a hard place. I've also raised this issue at the pgpool mailing list. IMHO, a decision needs to be made to either support missing syncs or forbid them. In the first case, pgpool needs to be adjusted, in the later case pgjdbc needs to be changed. Unfortunately, I'm not in the position to make this decision, nor can I fix pgpool or pgjdbc as I'm not familiar enough with the details on the protocol.

From the perspective of pgjdbc: would it hurt to do a sync when in extended mode and a simple query is about to be executed?

The discussion in the thread on pgsql-hackers ended with 'it would probably be a good idea to throw an error from the server side'. This is what pgpool is currently doing, but apparently this was never implemented in PostgreSQL itself, otherwise this would most likely have been addressed already in pgjdbc.

view thread (9+ messages)

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 #3724: Regression: FATAL:  simple query "BEGIN" arrived before ending an extended query message
  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