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@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Wang, Mary Y 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 |