On sun, 2007-06-24 at 17:58 +0800, carter ck wrote: > >From: Ragnar <gnari@xxxxxxx> > >On sun, 2007-06-24 at 16:55 +0800, carter ck wrote: > > > I am experiencing thgis problem since this morning. I seldom heard about > > > unique key constraint violation to happen when updating a table. > > > > > > It happens to 1 or few records at early stage, but then to all. > > > > > > My updating command is as following: > > > > > > update mytable set my_status='Y' where myid='ABC123567778'; > > > > > > Can anyone help? All helps and solutions are appreciated. > > > >sounds like you have a UNIQUE constraint involving the column > >"my_status". > > > >did you recently create a new index on this table? > > > >what does psql say to: > >\d mytable > > > > No. The only unique key is the myid, which is also the primary key. I have > extracted the records out from this database and dump all to a new database. > Everything is fine. But, this is the second time I have encountered this > problem. do you still have the old database around? if you do, does a REINDEX mytable; make your problem go away? gnari
