Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
(253) 245-3801

learn more about AGENCY or
follow the discussion.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux