Alexey Borzov <borz_off@rdw.ru> writes:
> rdw=# --finally, no more duplicates!
> rdw=# create unique index broken_email_key on broken (user_email);
> ERROR: Cannot create unique index. Table contains non-unique values
Seems pretty broken :-(
> rdw=# select version();
> version
> -------------------------------------------------------------
> PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
Uh, what is the platform exactly?
> As you probably guessed, reg_user table contains actual email
> addresses of our site's registered users. I can provide them for
> testing (without passwords and stuff, of course) if this is going to
> help.
If you could send me the email address data (off-list), I could try
to reproduce the problem here.
regards, tom lane