Updates failing yet saying they succeeded.

Поиск
Список
Период
Сортировка
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
Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Subject: bool / vacuum full bug followup part 2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: View vs. Statement Query Plan