Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group