Re: Unable to Update a Record - Mailing list pgsql-general

I tried to do (3) as well for reindex.
But I got this error:

reindex table users;
ERROR:  Cannot create unique index. Table contains non-unique values.

Do you know what does this mean?

Thanks in advance.

Mary Wang


-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Monday, August 01, 2005 11:08 PM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to Update a Record


Wang, Mary Y wrote:
> Richard,
>
> Thank you so MUCH. I was able to delete the record by using the OID
> method that you mentioned in (2).

Well, if the column I mentioned in (1) is integer/bigint, then you'll
want to do (3) as well and reindex.

--
   Richard Huxton
   Archonet Ltd