Itagaki Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp> writes:
> Vlad Arkhipov <arhipov(at)dc(dot)baikal(dot)ru> wrote:
>> Is it possible to print which key value is duplicated when 'Duplicate 
>> key value violates unique constraint' occurs? Foreign key violation 
>> error reports such kind of information.

> If no objection, I'd like to submit the patch to the next commit-fest (8.5).

I added this to CommitFest-2009-First.  One comment is that I'd prefer
to refactor this so it's not btree-specific, but could be used by other
index AMs.  I'm not quite sure where to put the code instead, though.

			regards, tom lane

In response to

• Re: Duplicate key value error at 2009-04-03 07:23:10 from Itagaki Takahiro

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2009-04-04 23:04:56
	Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT
Previous:	From: Tom Lane	Date: 2009-04-04 22:25:10
	Subject: Re: Review: B-Tree emulation for GIN