From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc:
"Peter Geoghegan" <peter(at)2ndquadrant(dot)com>,
"Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>,
"Robert Haas" <robertmhaas(at)gmail(dot)com>,
"Peter Eisentraut" <peter_e(at)gmx(dot)net>, "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 22:36:19
Message-ID:
3177.1335998179@sss.pgh.pa.us (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
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> writes:
>>> That "F0" class looks suspicious; are those really defined by
>>> standard or did we encroach on standard naming space with
>>> PostgreSQL-specific values?
>> I think we screwed up on that :-(. So we ought to renumber those
>> codes anyway. Perhaps use "PF" instead of "F0"?
> Sounds good to me.
I thought for a few minutes about whether we ought to try to sneak
such a change into 9.2. But given that we're talking about probably
doing a number of other SQLSTATE reassignments in the future, it
seems likely better to wait and absorb all that pain in a single
release cycle. It seems moderately unlikely that any client-side
code is dependent on these specific assignments, but still I'd rather
not see a dribble of "we changed some SQLSTATEs" compatibility flags
across several successive releases.
regards, tom lane
In response to
pgsql-hackers by date
Next :From: Robert HaasDate: 2012-05-02 23:18:15Subject : Re: Unnecessary WAL archiving after failoverPrevious :From : Robert HaasDate : 2012-05-02 22:23:44Subject : Re: online debloatification (was: extending relations more efficiently)
