Propose to change error code

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pgpool-hackers(at)lists(dot)postgresql(dot)org
Subject: Propose to change error code
Date: 2026-08-22 00:52:30
Message-ID: 20260822.095230.1783982792472615316.ishii@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgpool-hackers

Currently validate_backend_connectivity(src/protocol/child.c) reports
an error "08S01" to frontend when no backend is up. The error code
08S01 is not define in PostgreSQL document. So why 08S01? According to
Google, the code was used in old JDBC drivers and psqlODBC. Now JDBC
uses 08006 (defined in PostgreSQL as "connection_failure").

I think there's no reason for pgpool to keep on using the 08S501. I
propose to change it to 08006 (connection_failure) instead, like
JDBC. Note that I think it's better to fix it on master (v4.8) only to
not break existing frontend applications.

Regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

Browse pgpool-hackers by date

  From Date Subject
Next Message Koshino Taiki 2026-08-26 07:25:18 Re: Delimit query-cache key to prevent collisions
Previous Message Koshino Taiki 2026-08-20 08:44:44 Feature: Import PostgreSQL 19 new parser.