Re: Making pgsql error messages more developers' friendly.

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