logging arguments to prepared statements? - Mailing list pgsql-general

From rihad
Subject logging arguments to prepared statements?
Date
Msg-id 4767B688.8050606@mail.ru
Whole thread Raw
Responses Re: logging arguments to prepared statements?
List pgsql-general
Dec 18 15:49:41 myhost postgres[29832]: [35-1] ERROR:  23505: duplicate
key value violates unique constraint "foo_key"
Dec 18 15:49:41 myhost postgres[29832]: [35-4] INSERT INTO foo
Dec 18 15:49:41 myhost postgres[29832]: [35-5]    (a,b,c)
Dec 18 15:49:41 myhost postgres[29832]: [35-7] VALUES ($1,$2,$3)
Dec 18 15:49:41 myhost postgres[29832]: [35-8]

And that's it, leaving me wondering which value triggered the error. Any
way to tweak postgres to include the values too, without setting
log_statements=all?

changed log settings:
log_destination = 'syslog'
log_error_verbosity = verbose
log_min_error_statement = notice
log_checkpoints = on
log_connections = on
log_disconnections = on
log_lock_waits = on
log_statements = 'none'
log_temp_files = 0
log_autovacuum_min_duration = 250

other log_* settings kept as default (commented).

PostgreSQL 8.3-beta2 (FreeBSD port is lagging behind a bit).

Thanks.

pgsql-general by date:

Previous
From: Terry Fielder
Date:
Subject: Re: dblink does not connect when activated in a remote server
Next
From: "Josh Harrison"
Date:
Subject: Re: slony error --need help