Re: Updates failing yet saying they succeeded.

It looks like it's doing exactly what you are asking. Observe:

Oliver Jones sez:
} 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

Okay, updating RA2-1002998...

} autosupply_co_jp=> select fob_price from vehicle where chassis_number =
} 'RA2-1042998';
}  fob_price
} -----------
}     430000
} (1 row)

...but selecting on RA2-1042998.

} autosupply_co_jp=> update vehicle set fob_price = 420000 where
} chassis_number = 'RA2-1042998';
} UPDATE 1

This time, updating on RA2-1042998...

} autosupply_co_jp=> select fob_price from vehicle where chassis_number =
} 'RA2-1042998';
}  fob_price
} -----------
}     420000
} (1 row)

...and selecting on the same, RA2-1042998.

} WTF is up with that?

It didn't work the first time because you were not selecting the same thing
you'd updated. Pilot error.

[...]
} Oliver Jones > Software Engineer >
--Greg