> I agree with Tom here. I have used the Oracle NOWAIT feature in the > past and think it is a great feature IMHO. But when you need to use it, > you want it to apply very specifically to a single statement. Using a > sledge hammer when you need a tweezers isn't the right way to go.
Once I have written patches for 7.3 to implement this feature for LOCK statement. For example: test=# LOCK TABLE sales NO WAIT; ERROR: Cannot aquire relation lock If there's enough interest, I will modify and submit it for 7.5. -- Tatsuo Ishii ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
