Обсуждение: BUG #7666: Unkown column name on error message

The following bug has been logged on the website:

Bug reference:      7666
Logged by:          ROBSON
Email address:      robsonr.alencar@gmail.com
PostgreSQL version: 9.0.0
Operating system:   linux - ubuntu - pt_Br
Description:        =


After trying an insert on table, a error message is provided, but the column
name is not inserted in the message. Example:

"org.postgresql.util.PSQLException: ERRO: valor =C3=A9 muito longo para tipo
character varying(20)"

Java application, using JDBC Driver for PostgreSQL:
postgresql-9.1-901.jdbc4.jar

The column name is needed for best debug result.

On 16-11-2012 11:47, robsonr.alencar@gmail.com wrote:

[This is not a bug...]

> After trying an insert on table, a error message is provided, but the column
> name is not inserted in the message. Example:
>
> "org.postgresql.util.PSQLException: ERRO: valor é muito longo para tipo
> character varying(20)"
>
That message is coming from the postgres server and the details are available
to server and client.

> The column name is needed for best debug result.
>
Why don't you look at the postgres log? Or even better enable loglevel option
in the JDBC string connection?


--
   Euler Taveira de Oliveira - Timbira       http://www.timbira.com.br/
   PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento