Re: [HACKERS] lock table syntax - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] lock table syntax
Date
Msg-id 199803160440.XAA21933@candle.pha.pa.us
Whole thread Raw
In response to lock table syntax  (Zeugswetter Andreas DBT <Andreas.Zeugswetter@telecom.at>)
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 :-).

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)

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [QUESTIONS] MySQL benchmark page
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] VACUUM ANALYZE Problem