Postgres Pro
Downloads
Home   >   mailing lists

Re: Cannot insert a duplicate key into unique index - Mailing list pgsql-novice

From Tom Lane
Subject Re: Cannot insert a duplicate key into unique index
Date
Msg-id 25434.1058393067@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cannot insert a duplicate key into unique index  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-novice
Tree view 
Dmitry Tkach <dmitry@openratings.com> writes:
> As for 'what SQL code',  you can set debug_print_query=true in
> postgresql.conf - this will make it print all the sql queries you
> execute to the log file...

In recent releases (7.3 for sure, not sure about older ones) there
is also a log_min_error_statement setting that can be tweaked to log
only queries generating errors.

            regards, tom lane

pgsql-novice by date:

Previous
From: "Brian Johnson"
Date:
Subject: Re: Cannot insert a duplicate key into unique index
Next
From: HK
Date:
Subject: Display integer value as Hex.