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

From Tom Lane
Subject Re: [HACKERS] Syntax of LOCK TABLE ...
Date
Msg-id 24859.926870719@sss.pgh.pa.us
Whole thread Raw
In response to Syntax of LOCK TABLE ...  (David Sauer <davids@orfinet.cz>)
List pgsql-hackers
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...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Vazsonyi Peter
Date:
Subject: Re: [HACKERS] Re: sequences vs. transactions
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Syntax of LOCK TABLE ...