Re: Updates failing yet saying they succeeded.

On 4 Jun 2002, Oliver Jones wrote:

> I've been having a few problems with PgSQL not updateing data
> correctly.  Here is some evidence:
>
> autosupply_co_jp=> update vehicle set fob_price =420000 where
> chassis_number
> autosupply_co_jp-> = 'RA2-1002998';
> UPDATE 1
> autosupply_co_jp=> select fob_price from vehicle where chassis_number =
> 'RA2-1042998';
>  fob_price
> -----------
>     430000
> (1 row)
>
> autosupply_co_jp=> update vehicle set fob_price = 420000 where
> chassis_number = 'RA2-1042998';
> UPDATE 1
> autosupply_co_jp=> select fob_price from vehicle where chassis_number =
> 'RA2-1042998';
>  fob_price
> -----------
>     420000
> (1 row)
>
> WTF is up with that?

Is that a copy/paste error that the chassis numbers don't match in those
first statements?