Yes, I think it looks good. ---------------------------------------------------------------------------
Tatsuo Ishii wrote: > LOCK TABLE table NO WAIT is OK for 7.5? If ok, I will make patches > against current with some docs changes. > -- > Tatsuo Ishii > > > > Tatsuo Ishii wrote: > > > >>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 > > > > > > > > > That would be great. > > > Many people are asking for that. > > > Maybe I have time to implement that for SELECT FOR UPDATE. > > > > Here it is(against 7.3.3). > > -- > > Tatsuo Ishii > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED] > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
