From:
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:
<jkt(at)flaska(dot)net>,"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
"Robert Haas" <robertmhaas(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject:
Re: Re: [patch] Include detailed information about a row failing a CHECK constraint into the error message
Date:
2011-11-29 20:24:40
Message-ID:
4ED4EB2802000025000435F2@gw.wicourts.gov (view raw or flat )
Thread:
2011-11-09 23:48:09 from José Arthur Benetasso Villanova <jose(dot)arthur(at)gmail(dot)com>
2011-11-10 02:47:56 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-11-10 10:29:20 from Jan Kundrát <jkt(at)gentoo(dot)org>
2011-11-13 08:50:39 from Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
2011-11-10 10:40:58 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-10 11:41:00 from "Dickson S(dot) Guedes" <listas(at)guedesoft(dot)net>
2011-11-10 11:46:36 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-10 12:04:52 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-11-10 13:40:14 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-10 14:27:57 from Kääriäinen Anssi <anssi(dot)kaariainen(at)thl(dot)fi>
2011-11-10 15:05:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-11-10 15:21:45 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-11-10 15:37:41 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-11-10 15:56:32 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-16 22:13:33 from Royce Ausburn <royce(dot)ml(at)inomial(dot)com>
2011-11-21 13:59:59 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-21 14:52:56 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-11-23 22:05:07 from Robert Haas <robertmhaas(at)gmail(dot)com>
2011-11-29 17:51:55 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-11-29 18:39:40 from Jan Kundrát <jkt(at)flaska(dot)net>
2011-11-29 20:09:59 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2011-11-29 20:24:40 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
2011-11-10 09:25:09 from Jan Kundrát <kundratj(at)fzu(dot)cz>
Lists:
pgsql-hackers
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> I was wondering in particular whether it wouldn't be appropriate
> to include the same errdetail in ExecConstraints's other check,
> the one for null in not-null columns. Arguably a not-null check
> is just a slightly optimized form of a CHECK constraint, and
> anyway if you think you need row identification info for a CHECK
> failure I don't see why you'd not want it for NOT NULL failure.
> Comments?
Makes sense to me.
-Kevin
In response to
pgsql-hackers by date
Next :From: Bruce MomjianDate: 2011-11-29 20:34:40Subject : Re: Inlining comparators as a performance
optimisationPrevious :From : Tom LaneDate : 2011-11-29 20:09:59Subject : Re: Re: [patch] Include detailed information about a row failing a CHECK constraint into the error message
