From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
"Peter Eisentraut" <peter_e(at)gmx(dot)net>,
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Peter Geoghegan" <peter(at)2ndquadrant(dot)com>,
"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,
"Robert Haas" <robertmhaas(at)gmail(dot)com>,
"Noah Misch" <noah(at)leadboat(dot)com>,
"PostgreSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: proposal: additional error fields
Date:
2012-05-02 14:16:48
Message-ID:
4FA0FB8002000025000476DD@gw.wicourts.gov (view raw or flat )
Thread:
2012-05-01 12:21:24 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-05-01 12:45:11 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 13:01:26 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-05-01 13:19:16 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 13:55:49 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-01 15:09:40 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 20:14:08 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-01 20:36:32 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 21:09:56 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-05-01 23:07:19 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 23:22:15 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-01 21:20:15 from "David Johnston" <polobo(at)yahoo(dot)com>
2012-05-01 14:08:57 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-05-01 19:36:22 from Noah Misch <noah(at)leadboat(dot)com>
2012-05-01 19:59:49 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2012-05-01 20:09:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-02 00:05:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-05-02 00:13:05 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-02 01:01:48 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-02 07:23:29 from Peter Eisentraut <peter_e(at)gmx(dot)net>
2012-05-02 13:17:06 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-02 14:16:48 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-05-02 14:23:17 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-02 14:51:41 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2012-05-02 22:36:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2012-05-02 00:32:58 from David Johnston <polobo(at)yahoo(dot)com>
2012-05-02 04:02:12 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-05-01 20:14:02 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
2012-05-01 14:25:53 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-05-01 16:02:18 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-05-01 16:22:44 from Robert Haas <robertmhaas(at)gmail(dot)com>
2012-05-01 17:15:11 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2012-05-01 17:56:13 from Peter Geoghegan <peter(at)2ndquadrant(dot)com>
Lists:
pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> My guess is that all the ones defined in the SQL standard are
> "expected" errors, more or less by definition, and thus not
> interesting according to Peter G's criteria.
On a scan through the list, I didn't see any exceptions to that,
except for the "F0" class. To restate what the standard reserves
for standard SQLSTATE values in the form of a regular expression, it
looks like:
'^[0-4A-H][0-9A-Z][0-4A-H][0-9A-Z][0-9A-Z]$'
Eyeballing the errcode page in the docs, it looks like there are
PostgreSQL-assigned values that start with '5', 'P', and 'X'. That
"F0" class looks suspicious; are those really defined by standard or
did we encroach on standard naming space with PostgreSQL-specific
values?
We also have PostgreSQL-specific values in standard classes where we
use 'P' for the third character, which is fine.
-Kevin
In response to
Responses
pgsql-hackers by date
Next :From: Tom LaneDate: 2012-05-02 14:23:17Subject : Re: proposal: additional error fields Previous :From : Alexander KorotkovDate : 2012-05-02 13:57:05Subject : Re: Patch: add conversion from pg_wchar to multibyte
