Postgres Pro
Downloads
Home   >   mailing lists

Re: Do we have a range of SQLSTATE codes assigned for custom use? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Do we have a range of SQLSTATE codes assigned for custom use?
Date
Msg-id CAFj8pRCCJT8W-3iLPAcKHhOPUU=nsr0W8X3OwGWydjpDmr_XDQ@mail.gmail.com
Whole thread Raw
In response to Do we have a range of SQLSTATE codes assigned for custom use?  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-general
Tree view
Hello

User defined exceptions should to use "U0" class

We don't use it - but it should be documented.

but our implementation is less restrictive

Regards

Pavel Stehule



2014-03-24 2:42 GMT+01:00 Craig Ringer <craig@2ndquadrant.com>:
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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Thousands of errors...what happened?
Next
From: Amador Alvarez
Date:
Subject: Re: General Advice for avoiding concurrency during schema migrations