>>>Hi,
>>>
>>>I am trying to figure a way to parse an error message when a database constraint fails. The purpose is to make the error message more readable by an average user. I noticed that error message has a section 'constraint "Name_Of_Constraint'. My question is, can I rely that the syntax of error will always have the word 'constraint' before the name of the constraint in double quotes?
>>
>>If this is the same error, the error message is always going to be the same.
>
>I knew that. I want to know if the structure of error message will be the same regardless of the constraint causing it.
Yes.
If it's not broken, fix it until it is.
My Blog