propose: detail binding error log

From: Ioseph Kim <pgsql-kr(at)postgresql(dot)kr>
To: pgsql-hackers(at)postgresql(dot)org
Subject: propose: detail binding error log
Date: 2016-03-15 02:52:53
Message-ID: 1458010373.3935.15.camel@ioseph-centos
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, hackers.

I had a error message while using PostgreSQL.

"ERROR: 42804: column "a" is of type boolean but expression is of type
integer at character 25
LOCATION: transformAssignedExpr, parse_target.c:529"

This error is a java jdbc binding error.
column type is boolean but bind variable is integer.

I want see that value of bind variable at a server log.

java code:
pstmt = connection.prepareStatement("insert into test values (?)");
pstmt.setInt(1, 1);

I could not see that value at a server log, by changing any servier
configurations.

That case is debuged to client only.

So, I propose that error value of bind variable will be displayed at a
server log.

in parse_target.c:529,
input parameter value of that node not containded value of column at
client.

I want more detail error log.

Regards, Ioseph Kim

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2016-03-15 03:06:34 Re: propose: detail binding error log
Previous Message Alvaro Herrera 2016-03-15 02:40:44 Re: Timeline following for logical slots