lock table syntax - Mailing list pgsql-hackers

From Zeugswetter Andreas DBT
Subject lock table syntax
Date
Msg-id 219F68D65015D011A8E000006F8590C6010A51BA@sdexcsrv1.sd.spardat.at
Whole thread Raw
Responses Re: [HACKERS] lock table syntax  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: Andrew Martin
Date:
Subject: Re: [HACKERS] snapshot won't compile on irix6.2
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] (: JDBC+(Sun ~3:pm MST) CVS :) -also question about regression tests