AIL PROTECTED]> wrote:
> Ben Marklein <[EMAIL PROTECTED]> writes:
> > I'm trying to migrate from 7.2 to 7.4.1 via
> > pg_dump/pg_restore and have encountered a couple
> of
> > problems:
>
> > 1) Index creation on a table fails:
>
> > db=# CREATE
Did a pg_dump of a 7.2 DB and am now trying to restore
to 7.4.1. Index creation on a table fails:
db=# CREATE UNIQUE INDEX person_info_username_ix ON
person_info USING btree (username);
ERROR: could not create unique index
DETAIL: Table contains duplicated values.
Of course, this index existed
