Aditya Damle <adamle(at)2028(dot)com> writes:
> Then i went ahead reindexed the table: I recieved the error:
> Cannot create unique index. Table contains non-unique values.
Curious. When you say "reindexed" do you mean you used the REINDEX
command? That's new in 7.0.* and possibly not fully debugged. It
would be useful to see a complete script for reproducing the problem,
if you think you can regenerate it from scratch ...
regards, tom lane