Re: [HACKERS] FOR SHARE LOCK clause ?

> > I think lock escalation is nice.  Locking every row makes for lock
> > resource problems.  I would recommend locking a single row, and if a
> > second row needs to be locked, just escalate to lock the whole table...
> > if that can be done.  This would seem to be the most reasonable and
> > easiest to do.
> 
> Easiest to do is don't worry about # of locks -:)
> Let's be on this way for 6.5

You mean just share-lock the whole table.  I agree.  It is a pretty rare
situation.


--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026