I have a major search application in which I just put a new table in to store the clients that are linked to the appraisers. I made an index callled appclin which was str(appraiser_id) + str(client_id). I at first made this the primary index. I then realized because I am adding and subtracting appraiser_ids and client_ids that I was having problems with uniquiness of the index appclin being violated. I then changed the property on the index to be a regular index. Now every time I try use that table I get an error stating that I must rebuild the indicies. I've tried to validate the database, but it doesn't do much good.

Is there any way to remedy this problem?