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:[EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
