Re: [PATCHES] NO WAIT ...

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 majordomo(at)postgresql(dot)org
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073