Re: log bind parameter values on error
Alexey Bashtanov <bashtanov@imap.cc>
From: Alexey Bashtanov <bashtanov@imap.cc>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>,
PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-07-05T16:40:49Z
Lists: pgsql-hackers
Attachments
- log_parameters_v009.patch (text/x-patch) patch v9
Please find the rebased patch attached. Tested like the following. Provided you're in the postgres checkout and you've run make in src/test/examples/ and connected to db=postgres: CREATE SCHEMA testlibpq3; SET search_path = testlibpq3; CREATE TABLE test1_(i int4, t text, b bytea); INSERT INTO test1_ VALUES(0, '', ''); CREATE VIEW test1 AS SELECT 1/i i, t, b FROM test1_; -- will log only statement \! ./src/test/examples/testlibpq3 ALTER SYSTEM SET log_parameters_on_error TO on; SELECT pg_reload_conf(); -- will log statement with parameters \! ./src/test/examples/testlibpq3 Best regards, Alexey
Commits
-
Emit parameter values during query bind/execute errors
- ba79cb5dc841 13.0 landed
-
Add backend-only appendStringInfoStringQuoted
- 6cafde1bd43f 13.0 landed