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 :-).
Andreas
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)