[GENERAL] duplicate key violate error

2011-06-14 Thread AI Rumman
Hi, I got duplicate key violate error in the db log for the following query: INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS ( SELECT 1 FROM tab1 WHERE id='1611576' AND id2='1187865')) The error occured during production time. But when I manually executed the

Re: [GENERAL] duplicate key violate error

2011-06-14 Thread Albe Laurenz
AI Rumman wrote: I got duplicate key violate error in the db log for the following query: INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS ( SELECT 1 FROM tab1 WHERE id='1611576' AND id2='1187865')) The error occured during production time. But when I manually executed

Re: [GENERAL] duplicate key violate error

2011-06-14 Thread Merlin Moncure
On Tue, Jun 14, 2011 at 3:30 AM, AI Rumman rumman...@gmail.com wrote: Hi, I got duplicate key violate error in the db log for the following query: INSERT INTO tab1 ( SELECT '1611576', '1187865' WHERE NOT EXISTS ( SELECT 1 FROM tab1         WHERE id='1611576' AND id2='1187865'    )    ) The