Re: Duplicate key value error - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Duplicate key value error
Date
Msg-id 24655.1238885884@sss.pgh.pa.us
Whole thread Raw
In response to Re: Duplicate key value error  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp> writes:
> Vlad Arkhipov <arhipov@dc.baikal.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Review: B-Tree emulation for GIN
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... ALTER COLUMN ... SET DISTINCT