Re: Any hope for more specific error message for "value too long..."?

>
> I dug in the archives and came across a crude POC hack here:
>
> https://www.postgresql.org/message-id/21693.1478376334@sss.pgh.pa.us
>
> At the time I didn't want to pursue it further because of Andres'
> pending work on redoing expression execution, but that's landed now.
>
> regards, tom lane
>

For that matter, it's not totally
> clear what would constitute an improvement --- what do you wish it would
> show you, exactly?

It looks like that patch is about showing which value or where in the
statement the error is being caused. At least for my case, it would be
helpful to know which field is causing the error. And just guessing, but
maybe simpler? I'd be happy to see:

The error text was: ERROR *for field [field_name]*: value too long for
type character varying(10)

Cheers,
Ken

--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
ken(dot)tanzer(at)agency-software(dot)org
(253) 245-3801

Subscribe to the mailing list
<agency-general-request(at)lists(dot)sourceforge(dot)net?body=subscribe> to
learn more about AGENCY or
follow the discussion.