Rajesh Kumar Mallah <mallah@trade-india.com> 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