Thread

1. lock table syntax

   Zeugswetter Andreas <andreas.zeugswetter@telecom.at> — 1998-02-03T10:37:33Z

   Hullo,
   
   I seen the new lock table help in psql:
   I think we should stick to the (pseudo)standard syntax right from the
   beginning.
   Or maybe allow both, but i think at least the table keyword should be
   mandatory 
   to simplify implementation of other locks (like database).
   
   lock table <tablename> in {exclusive|share} mode;
   
   What we have now would conform to exclusive mode (works inside a
   transaction only, ok but
   that's the most important case :-).
   
   Andreas
   
   

2. Re: [HACKERS] lock table syntax

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-16T04:40:06Z

   > 
   > Hullo,
   > 
   > I seen the new lock table help in psql:
   > I think we should stick to the (pseudo)standard syntax right from the
   > beginning.
   > Or maybe allow both, but i think at least the table keyword should be
   > mandatory 
   > to simplify implementation of other locks (like database).
   > 
   > lock table <tablename> in {exclusive|share} mode;
   > 
   > What we have now would conform to exclusive mode (works inside a
   > transaction only, ok but
   > that's the most important case :-).
   
   Added to TODO list.
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
     +  If your life is a hard drive,     |  (610) 353-9879(w)
     +  Christ can be your backup.        |  (610) 853-3000(h)