BUG #13429: Update 0 rows for matching record - Mailing list pgsql-bugs

From smoola@travelclick.com
Subject BUG #13429: Update 0 rows for matching record
Date
Msg-id 20150610161919.2795.63005@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #13429: Update 0 rows for matching record
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      13429
Logged by:          Sandeep Moola
Email address:      smoola@travelclick.com
PostgreSQL version: 9.2.8
Operating system:   Red Hat Enterprise Linux Server release 6.5
Description:

We were trying to update a record in our database as below and the row was
not getting updated. No error was shown neither on the command promt nor in
the logs
STEP1:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
 yrd_cuttoff
-------------
 N
(1 row)

STEP2:
UPDATE yrd_yield_room_details SET yrd_cuttoff='NC' WHERE
yrd_yrd_key=10060451491;
UPDATE 0

STEP3:
SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE
yrd_yrd_key=10060451491;
 yrd_cuttoff
-------------
 N

pgsql-bugs by date:

Previous
From: q
Date:
Subject: Re: BUG #13413: pg_stat_statements don't statistics "DEALLOCATE ALL" statements
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #13429: Update 0 rows for matching record