Do we have a range of SQLSTATE codes assigned for custom use?

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Do we have a range of SQLSTATE codes assigned for custom use?
Date: 2014-03-24 01:42:20
Message-ID: 532F8D7C.3010408@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

With RAISE supporting user-defined SQLSTATEs, and EXCEPTION ... WHEN
supporting matching them, shouldn't we explicitly declare a range of
SQLSTATEs as reserved for custom use?

Right now, there's nothing in
http://www.postgresql.org/docs/current/static/errcodes-appendix.html to
tell a user which SQLSTATE codes they can use without any risk that
PostgreSQL will later use that code for something else.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rajeev rastogi 2014-03-24 04:32:27 Re: COPY error with null date
Previous Message Adrian Klaver 2014-03-24 01:39:30 Re: DB alias ?