>> Having a surrogate primary key shouldn't let you off the hook. As a>> rule of thumb, you always HAVE TO HAVE an alternate UNIQUE constraint.>I respectfully disagree with "always have to have." Yes, it may often>be necessary, but not always.

Can you suggest a situation where you do not need a unique constraint in
addition to the surrogate?