Обсуждение: logging

Поиск
Список
Период
Сортировка

logging

От
"Campbell, Lance"
Дата:

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

 

Re: logging

От
Tom Lane
Дата:
"Campbell, Lance" <lance@illinois.edu> writes:
> 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"

Update to 9.0.x.  There's no capability for this before that.

            regards, tom lane