Re: [HACKERS] FOR SHARE LOCK clause ?

> In any case, I'm not really sure what this locking
> in share mode would get you... could you explain
> in the context of the above examples.

I will take a stab at it.

Locking in shared mode would cause any row read by the SELECT to be
remain unmodified until its transaction completes.  Other SELECTs can
read it, but writer have to wait and can not modify it.

--  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