Add column name to error message?

Edson Richter <edsonrichter@xxxxxxxxxxx> · Tue, 18 Mar 2014 16:22:26 -0300



    Hi!

    
    I would like to have a improved error message with column name.
    Today (9.2.3), I receive the following error:

    
    "ERROR: value too long for type character varying(20)"

    
    Why not this more intuitive error message:

    
    "ERROR: value too long for type character varying(20) at column XYZ"

    
    Since my table can have more than one "character varying(20)"
    inside, would be useful to know which one has throw the error...

    Is there any reasoning (security, perhaps) for hiding column name in
    the error?

    
    Thanks,

    -- 

      
                Edson Carlos Ericksson Richter
              

              Sistemas para Bibliotecas, Escolinhas Infantis

                Projetos sob medida para sua empresa
            
          
            Celular:
            (51) 9318-9766

                (51) 8585-0796
          
          
              "A mente que se abre a uma nova ideia jamais voltará ao
                seu tamanho original"

              - Albert Einstein