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
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 |