lock table syntax

Started by Zeugswetter Andreas DBTalmost 28 years ago2 messages
#1Zeugswetter Andreas DBT
Andreas.Zeugswetter@telecom.at

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

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Zeugswetter Andreas DBT (#1)
Re: [HACKERS] lock table syntax

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)