An oil pressure warning light that comes on at idle but goes out as engine speed rises could indicate

Correct answer to question 158 (Auto & Shop Information): worn engine bearings increasing clearance at low pump output

Method

Worn bearings widen the clearance oil must fill, and at idle the pump's slower output cannot maintain pressure through that larger gap; higher rpm speeds up the pump enough to mask the problem temporarily.