Re: primary key error message - Mailing list pgsql-hackers

From Tom Lane
Subject Re: primary key error message
Date
Msg-id 13520.1264107069@sss.pgh.pa.us
Whole thread Raw
In response to Re: primary key error message  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: primary key error message
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Jan 21, 2010 at 3:30 PM, Peter Eisentraut <peter_e@gmx.net> wrote:
>> Here is a small patch that changes the error message
>> 
>> � �duplicate key value violates unique constraint "%s"
>> 
>> into
>> 
>> � �duplicate key value violates primary key "%s"
>> 
>> when the constraint is in fact a primary key.
>> 
>> Comments?

> Why bother?  And why bother now, when we're in the middle of the last
> CommitFest and trying to move toward a release?

This patch fails to cover all cases (index build being the obvious
omission, but I think there might be other paths as well where the
information is not so readily available).  And I agree with Robert
that the usefulness is at best highly debatable.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: primary key error message
Next
From: Tom Lane
Date:
Subject: Re: PITR backup history files with identical 2nd part file names