Re: Unable to Update a Record

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(at)archonet(dot)com]
Sent: Monday, August 01, 2005 11:08 PM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-general(at)postgresql(dot)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