Wang, Mary Y wrote:
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?
Just what it says. Somehow your table has got corrupted, possibly with
an old and a new
]
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 i
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
--
-general@postgresql.org
Subject: Re: [GENERAL] Unable to Update a Record
Wang, Mary Y wrote:
> Sorry, that I didn't explain my problem very clearly.
> Anyway, here is the deal:
>
> I'm the admin for the database, so, I've all the privileges of
> updating, deletion, a
Wang, Mary Y wrote:
Sorry, that I didn't explain my problem very clearly.
Anyway, here is the deal:
I'm the admin for the database, so, I've all the privileges of updating,
deletion, and reviewing and et.
When I tried to select based on the bemsid condition, TWO ROWS returned:
select * from
a D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, July 29, 2005 5:18 PM
To: Wang, Mary Y
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Unable to Update a Record
Wang, Mary Y wrote:
> Hi,
>
> I'm running postgressql 7.1.3-2.
> I've a
>
> When I did a select
Title: Message
Are you sure that your user account has
been granted DELETE and UPDATE on that table?
If you are sure that the account you were
connected with has permissions, then:
Give the exact command
you did to perform the select.
Give the exact result set
you got back when
Wang, Mary Y wrote:
Hi,
I'm running postgressql 7.1.3-2.
I've a
When I did a select on the table, I was able to see that row. However,
when I tried to update that row, I got 'Update 0', I even tried to
delete that row, I couldn't. It seems like the database is confused. I
did the Vacu
