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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Sauer <davids(at)orfinet(dot)cz>
Cc: pgsql-hackers(at)hub(dot)org
Subject: Re: [HACKERS] Syntax of LOCK TABLE ...
Date: 1999-05-16 16:05:19
Message-ID: 24859.926870719@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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...

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vadim Mikheev 1999-05-16 16:14:17 Re: [HACKERS] Syntax of LOCK TABLE ...
Previous Message Vazsonyi Peter 1999-05-16 15:11:55 Re: [HACKERS] Re: sequences vs. transactions