Re: Add column name to error message?

From: Edson Richter <edsonrichter(at)hotmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Add column name to error message?
Date: 2014-03-18 20:22:55
Message-ID: BLU0-SMTP477EF9800EDD1DA6EB5BC4FCF7C0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 18/03/2014 17:17, Francisco Olarte escreveu:
> Hi:
>
>
> On Tue, Mar 18, 2014 at 8:22 PM, Edson Richter
> <edsonrichter(at)hotmail(dot)com <mailto:edsonrichter(at)hotmail(dot)com>> wrote:
>
> 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?
>
>
> Maybe they are not hiding it, but the error is raised by a value
> checking routine which does not know where the value comes from / goes
> to ( ie, it's a 'check_varchar(xx, maxlen), which is used to check
> columns, function aprameters, type casts....) ( that happens to me in
> my own code in some places where the context / error message is
> extremely difficult to propagate down / up ) .
>
> Francisco Olarte.

Thanks, Francisco. I don't know internals.
But, doesn't the "value checking routing" caller's know which column is
being tested?

Regards,
--

*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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-03-18 20:44:54 Re: Add column name to error message?
Previous Message Edson Richter 2014-03-18 19:22:26 Add column name to error message?