pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem

From: Taiki Koshino <koshino(at)sraoss(dot)co(dot)jp>
To: pgpool-committers(at)lists(dot)postgresql(dot)org
Subject: pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem
Date: 2026-10-21 01:55:29
Message-ID: E1xJLY9-00000008Zm7-0L0a@gothos.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-committers

Fix SQLSTATE for Bind referencing a nonexistent prepared statement.

When Bind referenced a nonexistent prepared statement, Pgpool-II returned
SQLSTATE XX000 (internal_error), whereas PostgreSQL returned 26000
(invalid_sql_statement_name). The error messages were the same, but the
SQLSTATE values were inconsistent.

Change the SQLSTATE to 26000 to match PostgreSQL. The error message and
connection recovery behavior remain unchanged.

Author: Taiki Koshino koshino(at)sraoss(dot)co(dot)jp
Discussion: https://github.com/pgpool/pgpool2/issues/180
Backpatch-through: v4.3

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=ccb1c06acd1f2480a4445549265e8de3623908cd

Modified Files
--------------
src/protocol/pool_proto_modules.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)

Browse pgpool-committers by date

  From Date Subject
Next Message Taiki Koshino 2026-10-21 01:56:26 pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem
Previous Message Tatsuo Ishii 2026-10-19 00:14:26 pgpool: Doc: enhance note of allow_clear_text_frontend_auth.