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
]
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
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
]
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 on the table, I was able to see that row.
However,
when I tried
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
-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, and reviewing and et.
When I
Title: Message
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 Vacuum,
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
To: pgsql-general@postgresql.org
Subject: [GENERAL] Unable to
Update a Record
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