Updates failing yet saying they succeeded.

From: Oliver Jones <oliver(at)deeper(dot)co(dot)nz>
To: pgsql-general(at)postgresql(dot)org
Subject: Updates failing yet saying they succeeded.
Date: 2002-06-04 05:11:37
Message-ID: 1023167497.2626.34.camel@duality.area51.deeper.co.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)deeper(dot)co(dot)nz
> www.deeperdesign.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-06-04 05:15:38 Re: View vs. Statement Query Plan
Previous Message N4sir Simbolon 2002-06-04 03:08:32 Re: Problems while compiling php_4-2.1 with PostgreSQL