| 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: | Whole Thread | Raw Message | 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 |