How do I know what constraint I just violated?

[nickretallack]

When I exec a query that violates a constraint, I get an error back, but unfortunately the fields in it seem to be opaque to me. What is most of interest in the error is the name of the constraint that the query violated. Based on this, I could prepare a friendly message to the user explaining what the problem with their request is.

I suppose I could parse the error string given by Error(), but if there were a friendlier way to get at that constraint name, that would be nice.

[nickretallack]

Oh cool. I inspected an error and found the info I was looking for.

err.(*pq.Error).Constraint

[bmizerany]

Can we close this? Also, pq is now at lib/pq.

[bmizerany]

Closing. Please re-post at http://github.com/lib/pq if there is still a problem.