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
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 |