logging

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: logging
Date: 2011-05-06 14:52:20
Message-ID: B10E6810AC2A2F4EA7550D072CDE8760083A0FD9@SAB-FENWICK.sab.uiuc.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I currently use PostgreSQL 8.4.x.

Below is a message I see in my logs. How can I display the values for
$1, $2, etc. within the logs?

ERROR: duplicate key value violates unique constraint "table_name_pkey"

STATEMENT: insert into schema_name.table_name(field1, field2, field3,
field4, field5) values($1, $2, $3, $4, $5)

Thanks,

Lance Campbell

Software Architect/Project Manager/DBA

University of Illinois

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-05-06 15:12:02 Re: logging
Previous Message Tomasz Chmielewski 2011-05-06 08:42:17 Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?