Re: [GENERAL] Unable to Update a Record

[Dann Corbit]

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 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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   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