From: | "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com> |
---|---|
To: | "Richard Huxton" <dev(at)archonet(dot)com> |
Cc: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Unable to Update a Record |
Date: | 2005-08-02 16:39:34 |
Message-ID: | 8C5D1947714C254FBA98D176B86DEAB8AA4CD5@XCH-SW-3V1.sw.nos.boeing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-08-02 16:42:40 | Re: Problem with dropping a tablespace |
Previous Message | Dan Armbrust | 2005-08-02 16:34:40 | BUG #1552 followup |