logging - Mailing list pgsql-admin

From Campbell, Lance
Subject logging
Date
Msg-id B10E6810AC2A2F4EA7550D072CDE8760083A0FD9@SAB-FENWICK.sab.uiuc.edu
Whole thread Raw
Responses Re: logging
List 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

 

pgsql-admin by date:

Previous
From: Tomasz Chmielewski
Date:
Subject: Re: 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?
Next
From: Tom Lane
Date:
Subject: Re: logging