Richard,
Thank you so MUCH. I was able to delete the record by using the OID
method that you mentioned in (2).
Thanks again.
Mary Wang
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: Monday, August 01, 2005 9:44 AM
To: Wang, Mary Y
Cc: Joshua D. Drake; pgsql-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 tried to select based on the bemsid condition, TWO ROWS
> returned:
>
> select * from users where bemsid=949762;
>
> user_id | user_name | email | user_pw |
realname
> 4215 | 949762 | john.a.hoff@boeing.com | | Hoff, John A
|
>
> But when I tried select user_id=4215, the result return 0 rows:
>
> select * from users where user_id=4215;
> user_id | user_name | email | user_pw | realname | status | shell |
> -----+----------------------+---------------------
> (0 rows)
>
> I'm really confused. I want to delete user_id=4215 because it is
> causing me login errors. But I can't select, update, delete that
> record. I'm not sure if that record really exist.
1. What type is "user_id"?
If it's a text-type, there could be unseen spaces interfering.
2. Try selecting the OID too (SELECT oid,* FROM ...) with your first
query, then use that oid in your where clause. Can you see it now? Of
course, this assumes you have oids defined for this table.
3. Have you tried re-indexing the table (REINDEX TABLE users) It's
possible the index has become corrupted while the data is fine.
--
Richard Huxton
Archonet Ltd