Re: [GENERAL] duplicate key violate error

2011-06-14 Thread Merlin Moncure
On Tue, Jun 14, 2011 at 3:30 AM, AI Rumman 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 error occured

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 exe

[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 query