propose: detail binding error log

Поиск
Список
Период
Сортировка
От Ioseph Kim
Тема propose: detail binding error log
Дата
Msg-id 1458010373.3935.15.camel@ioseph-centos
обсуждение исходный текст
Ответы Re: propose: detail binding error log  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: propose: detail binding error log  (Craig Ringer <craig@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Minor bug affecting ON CONFLICT lock wait log messages
Следующее
От: Tom Lane
Дата:
Сообщение: Re: propose: detail binding error log