From: | "Tigran Mkrtchyan" <tigran(dot)mkrtchyan(at)desy(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #6300: duplicate key value violates unique constraint |
Date: | 2011-11-18 16:42:36 |
Message-ID: | 201111181642.pAIGgaLY007885@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 6300
Logged by: Tigran Mkrtchyan
Email address: tigran(dot)mkrtchyan(at)desy(dot)de
PostgreSQL version: 9.0.4
Operating system: Linux x86_64
Description: duplicate key value violates unique constraint
Details:
Hi,
our application uses PostgreSQL as a backend and heavily
relays on transactions. We never check constrains in our application as DB
does is better than we can an in an atomic way. This works very-very good!
Nevertheless the logfiles are full of 'duplicate key value violates unique
constraint'. I have two questions:
1. why it logged with ERROR level as it clients application behavior.
2. is there a way to suppress it or could you add a way to suppress it.
Thanks a lot,
Tigran.
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Vondra | 2011-11-18 17:52:30 | Re: BUG #6300: duplicate key value violates unique constraint |
Previous Message | Kevin Grittner | 2011-11-18 16:01:54 | Re: "like" and "ilike" not working properly on postgresql 9.0.3 where clause, bug fix not mentioned on 9.0.5 either |