>Craig,
>
>>>So how do you keep the attribute that was used as a primary key before unique ??
>
>>Candidate Key.
>
>I suppose you implement this with a Candidate index.
>
>So, how do you prevent an error if a user inserts a certain (candidate key), deletes, and tries to insert the same key again ?

Don't recycle candidate keys.