In postgres Updates 0 rows for matching record

Question

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

STEP 1:

SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE yrd_yrd_key=1491;  
yrd_cuttoff
________________
 N
(1 row)

STEP 2:

UPDATE yrd_yield_room_details SET yrd_cuttoff='NC' WHERE yrd_yrd_key=1491; 

UPDATE 0

STEP 3:

SELECT yrd_cuttoff FROM yrd_yield_room_details WHERE yrd_yrd_key=1491;  

yrd_cuttoff
________________
 N
(1 row)

Answer 1

Check if there is no rules on this table. See this and this.