| From: | rihad <rihad(at)mail(dot)ru> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | logging arguments to prepared statements? |
| Date: | 2007-12-18 12:01:12 |
| Message-ID: | 4767B688.8050606@mail.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Harrison | 2007-12-18 13:08:34 | Re: slony error --need help |
| Previous Message | Terry Fielder | 2007-12-18 11:54:42 | Re: dblink does not connect when activated in a remote server |