Re: Appendix A. PostgreSQL Error Codes

2018-04-28 Thread Jonathan S. Katz
> On Apr 28, 2018, at 5:11 PM, Tom Lane wrote: > > "Andy Dossett" writes: >> The use case is pretty simple; my system has thrown an SQL error code, I >> want to know what it means. >> Having the list in 'order by sqlstate' sequence would save me from having to >> hunt up and down the list. And

Re: Appendix A. PostgreSQL Error Codes

2018-04-28 Thread Tom Lane
"Andy Dossett" writes: > The use case is pretty simple; my system has thrown an SQL error code, I > want to know what it means. > Having the list in 'order by sqlstate' sequence would save me from having to > hunt up and down the list. And I can easily determine if the error code is > missing; I c

RE: Appendix A. PostgreSQL Error Codes

2018-04-28 Thread Andy Dossett
nother bug report. Regards Andy Dossett -Original Message- From: Tom Lane Sent: 27 April 2018 16:16 To: Bruce Momjian Cc: doss...@btinternet.com; pgsql-docs@lists.postgresql.org Subject: Re: Appendix A. PostgreSQL Error Codes Bruce Momjian writes: > On Fri, Apr 27, 2018 at 10:08:1

Re: Appendix A. PostgreSQL Error Codes

2018-04-28 Thread Jürgen Purtz
The SQL standard sorts the SQLSTATE table in a first step according to the *textual representation* of class (first two byte) and in a second step to the textual representation of subclass (next 3 byte) - keeping the text '(no subclass)' for subclass '000' on top. Obviously for some people this

Re: Appendix A. PostgreSQL Error Codes

2018-04-27 Thread Tom Lane
Bruce Momjian writes: > On Fri, Apr 27, 2018 at 10:08:12AM +, PG Doc comments form wrote: >> Would it be possible to present the codes in ascending sequence? > Uh, I am guessing this is the order listed in the SQL standard. How > would you order them differently? Have the letters only at th

Re: Appendix A. PostgreSQL Error Codes

2018-04-27 Thread Bruce Momjian
On Fri, Apr 27, 2018 at 10:08:12AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/static/errcodes-appendix.html > Description: > > Hi > Would it be possible to present the codes in ascending seq

Appendix A. PostgreSQL Error Codes

2018-04-27 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/static/errcodes-appendix.html Description: Hi Would it be possible to present the codes in ascending sequence? This applies to all releases. Thanks