propose: detail binding error log - Mailing list pgsql-hackers

From Ioseph Kim
Subject propose: detail binding error log
Date
Msg-id 1458010373.3935.15.camel@ioseph-centos
Whole thread Raw
Responses Re: propose: detail binding error log
Re: propose: detail binding error log
List 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




pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Minor bug affecting ON CONFLICT lock wait log messages
Next
From: Tom Lane
Date:
Subject: Re: propose: detail binding error log