Postgres Pro
Downloads
Home   >   mailing lists

Re: Add column name to error message? - Mailing list pgsql-general

From Edson Richter
Subject Re: Add column name to error message?
Date
Msg-id BLU0-SMTP477EF9800EDD1DA6EB5BC4FCF7C0@phx.gbl
Whole thread Raw
In response to Add column name to error message?  (Edson Richter <edsonrichter@hotmail.com>)
Responses Re: Add column name to error message?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Em 18/03/2014 17:17, Francisco Olarte escreveu:
Hi:


On Tue, Mar 18, 2014 at 8:22 PM, Edson Richter <edsonrichter@hotmail.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

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Add column name to error message?
Next
From: Tom Lane
Date:
Subject: Re: Add column name to error message?