Re: [HACKERS] Syntax of LOCK TABLE ...

> Tom Lane wrote:
> >
> > David Sauer <davids(at)orfinet(dot)cz> writes:
> > > => lock table t row share mode;
> > > LOCK TABLE
> > > ... this works
> > > but:
> > > => lock table t IN row share mode;
> > > ERROR: parser: parse error at or near "in"
> > > .... but this not
> >
> > > It is mistake in grammar, or is there all OK ?
> >
> > I see this behavior too, and a quick look at gram.y shows that indeed
> > it is not expecting IN in a LOCK statement. I do not know whether the
> > standard permits (or requires?) the IN keyword, so I don't know whether
> > to make the change...
>
> IN is required...

I have modified the grammar to require IN. Looks like someone cleaned
up the LOCK grammar options recently, but forgot the IN.

--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026