Updates failing yet saying they succeeded.
От | Oliver Jones |
---|---|
Тема | Updates failing yet saying they succeeded. |
Дата | |
Msg-id | 1023167497.2626.34.camel@duality.area51.deeper.co.nz обсуждение исходный текст |
Ответы |
Re: Updates failing yet saying they succeeded.
Re: Updates failing yet saying they succeeded. Re: Updates failing yet saying they succeeded. |
Список | 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
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
--
|
Вложения
В списке pgsql-general по дате отправления: