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
