Re: [HACKERS] Syntax of LOCK TABLE ... - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Syntax of LOCK TABLE ...
Date
Msg-id 199905170022.UAA17362@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Syntax of LOCK TABLE ...  (Vadim Mikheev <vadim@krasnet.ru>)
List pgsql-hackers
> Tom Lane wrote:
> > 
> > David Sauer <davids@orfinet.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@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [HACKERS] How good is FreeBSD for postgres ?
Next
From: Bruce Momjian
Date:
Subject: sgmr* vs. md*