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@xxxxxxxxxxxx] Sent: Monday, August 01, 2005 11:08 PM To: Wang, Mary Y Cc: Joshua D. Drake; pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
