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:57:14
Message-ID: E1xJLZq-00000008aLA-10eI@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_6_STABLE

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

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:57:29 pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem
Previous Message Taiki Koshino 2026-10-21 01:56:26 pgpool: Fix SQLSTATE for Bind referencing a nonexistent prepared statem