Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
> Would I be correct in assuming that the following two indexes are
> completely redundant except for the fact that one complains about
> uniqueness constraint violations and the other does not?
Yup ...
regards, tom lane