Re: Cannot insert a duplicate key into unique index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dmitry Tkach <dmitry(at)openratings(dot)com>
Cc: Brian Johnson <bjohnson(at)johnson-engineering(dot)ca>, pgsql-novice(at)postgresql(dot)org
Subject: Re: Cannot insert a duplicate key into unique index
Date: 2003-07-16 22:04:27
Message-ID: 25434.1058393067@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dmitry Tkach <dmitry(at)openratings(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message mohammed rafique 2003-07-17 09:04:32 c postgres connectivity
Previous Message Brian Johnson 2003-07-16 21:29:33 Re: Cannot insert a duplicate key into unique index