PostgreSQL 9.5.2
PostgreSQL JDBC42 – 9.4.1208 JDBC42
I have logging turned on in PostgreSQL. I had an error message that OFFSET must not be negative. I get that. No problem. Then underneath that line in the log file is the STATEMENT: . The SQL is displayed. In JAVA I use prepared statements. So the SQL statement is displayed includes this fk_xyz_id=? . I cannot identify the issue in my web application without knowing what the value is for “?”. If I did I might be able to recreate the issue in order to fix it.
Is there a way to tell PostgreSQL to display the actual SQL statement? If not then why not? It seems like PostgreSQL has to know what the value is for the “?” in order to actually execute the query. Or am I missing something? If there is not a way for PostgreSQL to display the value of the question mark then could someone explain to me why? I must not understand a fundamental relationship between the database and the PostgreSQL JDBC driver.
Thanks,
Lance