Rajesh Kumar Mallah <[EMAIL PROTECTED]> writes: > Shudnt' messages like > ERROR: value too long for type character varying(5) > Indicate which column and table the server is talking about .
Send a patch ;-) This is not that easy to do: the code that implements the constraint does not know what it is being applied to. In the general case it cannot know, because there may be no specific table/column it's being applied to --- consider "SELECT 'foobar'::char(5)". But if you have an idea how to give a more-specific error message when possible, let's see some code. (Possible plan: the recently-added error context mechanism might be able to do something for this...) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])