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