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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Wang, Mary Y
Sent: Friday, July 29, 2005 4:51 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Unable to Update a Record
I'm running postgressql 7.1.3-2.
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.
