On Thu, Sep 27, 2007 at 02:48:52PM +0530, Anoo Sivadasan Pillai wrote: > Description : I have two tables with the same data , While I issue an > update command to increment the value of a unique field by 1, the > statement fails in one table and will succeed in the other table. > Following is the script to reproduce the behaviour.
Correct. Unique constraints are not deferrable. I'm sure there are people who would like it fixed, but there is currently not even a proposal on how to do it. It's a hard problem, for which there are well-known work-arounds. In practice this problem don't come up too often. It's been on the TODO list for at least 5 years... Have a nice day, -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > From each according to his ability. To each according to his ability to > litigate.
Description: Digital signature