Message-ID: <gh-pgjdbc-pgjdbc-3779@github.com>
From: "ivan-ra (@ivan-ra)" <noreply+ivan-ra@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Wed, 20 Aug 2025 18:17:33 +0000
Subject: [pgjdbc/pgjdbc] issue #3779: SQLException subclasses support
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Author-Id: 1991195
X-GitHub-Author-Login: ivan-ra
X-GitHub-Issue: 3779
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/3779
Content-Type: text/plain; charset=utf-8

SQLException class has many descendants: SQLRecoverableException, SQLSintaxErrorException, SQLTimeoutException, etc... Application developer can catch this exceptions in code to do specific processing.
But for now pgjdbc driver for all errors raises only PSQLException. Of course, it possible to find exception cause by parsing exception message, but it requires custom code,  It makes postgres exception handling non-portable. It would be nice if the driver could find the cause of the error on its own and throw a corresponding exception. 
Do you have plans to support all (or some) SQLException subclasses?