Re: Unique Constraint Violation

Robin Cawsey said: > Hi, > > I have come across a rather nasty error that only appears to > surface at random times. I have created a table with four columns and > three of the columns I have chosen to generate the Primary Key for the > table (Due to the nature of the data I have not been able to use a > serial field). I also have an application that inserts data into the > table, (like you would). However know and again I have noticed that > inserts seem to fail and the informix DB complains that the a unique > constraint has been violated on the Primary key, however I have check > the contents of the key and have found no reason why it should > complain since the overall contents of the primary key is unique each > time. > > Any help towards a reason why would be very welcome. oncheck your indexes, you might have a corrupt index? Just a guess though... -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "I'm trying to see things your way, but I can't get my head up my ass" - JCH "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco http://www.catb.org/~esr/faqs/smart-questions.html sending to informix-list