Re: [PATCHES] NO WAIT ...

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