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