On 15 March 2016 at 15:06, Ioseph Kim wrote:
> case 2: in jdbc program.
> ERROR: 42804: column "a" is of type boolean but expression is of type
> integer at character 25
> HINT: You will need to rewrite or cast the expression.
> LOCATION: transformAssignedExpr, parse_target.c:529
> STATEMENT:
thanks for reply.
Craig wrote:
>> At the time PostgreSQL parses the statement it doesn't know the
>> parameter values yet, because PgJDBC hasn't sent them to it. It
>> cannot log them even if they mattered, which they don't.
I know already that, so I wrote how can see error value at server log
On 15 March 2016 at 10:52, Ioseph Kim wrote:
> 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
thanks for reply.
value of log_statement is already 'all'
I set log_min_messages = debug5, log_error_verbosity = verbose and
debug_print_parse = on too.
but I could not a value of client in server log.
this case is occured only at jdbc prepare statement and wrong type
binding.
reguards, Ioseph.
Ioseph Kim writes:
> I want see that value of bind variable at a server log.
That's available if you turn on log_statements, IIRC.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.p
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 in