Search Postgresql Archives

Re: Unable to Update a Record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Wang, Mary Y
Sent: Friday, July 29, 2005 4:51 PM
To: pgsql-general@xxxxxxxxxxxxxx
Subject: 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

 

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux