Updates failing yet saying they succeeded. - Mailing list pgsql-general

From Oliver Jones
Subject Updates failing yet saying they succeeded.
Date
Msg-id 1023167497.2626.34.camel@duality.area51.deeper.co.nz
Whole thread Raw
Responses Re: Updates failing yet saying they succeeded.  (Gregory Seidman <gss+pg@cs.brown.edu>)
Re: Updates failing yet saying they succeeded.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Updates failing yet saying they succeeded.  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-general
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?

[oliver] hostility:~$ rpm -qa |grep post
postgresql-7.1.3-1PGDG
postgresql-server-7.1.3-1PGDG
postgresql-docs-7.1.3-1PGDG
postgresql-jdbc-7.1.3-1PGDG
postgresql-libs-7.1.3-1PGDG
postgresql-devel-7.1.3-1PGDG
postgresql-odbc-7.1.3-1PGDG
postgresql-perl-7.1.3-1PGDG
postgresql-tk-7.1.3-1PGDG
postgresql-tcl-7.1.3-1PGDG

Regards
--
Oliver Jones > Software Engineer > Deeper Design Limited.
oliver@deeper.co.nz  > www.deeperdesign.com
Attachment

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Subject: bool / vacuum full bug followup part 2
Next
From: Tom Lane
Date:
Subject: Re: View vs. Statement Query Plan