Duplicate Key Error Message Very Vague

From: "Campbell, Lance" <lance(at)uiuc(dot)edu>
To: "posgres support" <pgsql-admin(at)postgresql(dot)org>
Subject: Duplicate Key Error Message Very Vague
Date: 2008-04-08 16:05:19
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760CDDCA8@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Duplicate Key Error Message Very Vague,

I got the following message when doing an update:

duplicate key violates unique constraint "user_role_pkey"

Is there a reason PostgreSQL could not be modified to tell us the values
of the keys so we could then trouble shoot the issue?

Example: If the primary field was field1 and field2 then the error
message would say:

duplicate key violates unique constraint "user_role_pkey", values of
123, 'abcd' were used.

Thanks,

Lance Campbell

Project Manager/Software Architect

Web Services at Public Affairs

University of Illinois

217.333.0382

http://webservices.uiuc.edu

Browse pgsql-admin by date

  From Date Subject
Next Message yawei hou 2008-04-08 16:32:10 CREATE LANGUAGE cannot load library ERROR!
Previous Message Tena Sakai 2008-04-08 15:47:06 Re: Handling large volumes of data