Re: Hacking gram.y Error syntax error at or near "MERGEJOIN"

On 02.06.2011 15:16, Andrew Dunstan wrote:
> On 06/02/2011 03:28 AM, HuangQi wrote:
>> Hi,
>> I'm doing a hacking project which hacks the gram.y file and some other
>> so that postgres can execute some query plan language to run a
>> particular plan. I did some modifications and try run it. It compiled
>> and installed successfully. But when I was trying to run a MergeJoin
>> operation with keyword MERGEJOIN, it says "ERROR: syntax error at or
>> near 'MERGEJOIN'". It seems postgres didn't recognize this keyword. Is
>> it caused by any error inside gram.y? Or how can I trace this error?
>
> Without seeing your grammar changes and the statement you're trying to
> execute it's pretty much impossible to tell.

Yeah. One more guess is that you didn't include the keyword in the 
keyword list at the end of gram.y. There's script to check various 
keyword-related things at src/tools/check_keywords.pl

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com