Re: Unable to Update a Record

Wang, Mary Y wrote:
> 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.

It would probably be helpful to see what query you are running, the
table information... things like that.

>
> Any suggestions?
>
> Thanks
> Mary Wang
>
>
>


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/