Re: Unable to Update a Record

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unable to Update a Record
Date: 2005-07-30 00:17:50
Message-ID: 42EAC72E.2060908@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2005-07-30 00:19:34 Re: Unable to Update a Record
Previous Message William Bug 2005-07-30 00:16:20 Inheritance vs. LIKE - need advice