Re: sorting/grouping/(non-)unique indexes bug

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