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:58:01
Message-ID: E1xJLaa-00000008aW8-3xB0@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
------
V4_3_STABLE

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

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 02:13:18 pgpool: Fix extended-protocol DISCARD ALL and statement reuse after DIS
Previous Message Taiki Koshino 2026-10-21 01:57:44 pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem