Peter,
> update lr_object_usage set status = (case when status = ''OPEN_SUCC''
> then ''CLOSED_SUCC'' when status = ''OPEN_FAIL'' then
> ''CLOSED_FAIL'');
You're missing something:
update lr_object_usage set status = (case when status = ''OPEN_SUCC''
then ''CLOSED_SUCC'' when status = ''OPEN_FAIL'' then
''CLOSED_FAIL'' END);
FYI, in the future, please e-mail the error you get as well as your
question. It helps us diagnose the problem.
-Josh Berkus