Re: Unable to Update a Record

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 you did the select.

Give the exact command you did to perform the update.

Give the exact command you did to perform the delete.

Were there any sort of error messages?

________________________________

From: pgsql-general-owner(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Wang, Mary Y
Sent: Friday, July 29, 2005 4:51 PM
To: pgsql-general(at)postgresql(dot)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 that row, I couldn't. It seems like the database is confused. I
did the Vacuum, but still didn't help.

Any suggestions?

Thanks
Mary Wang