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

2011-06-03 Thread HuangQi
Thanks all for your ideas. Though wired, I reinstalled the Postgres and tried again. This error message disappears. The parser now works good. On 3 June 2011 01:13, Alvaro Herrera wrote: > Excerpts from HuangQi's message of jue jun 02 11:17:21 -0400 2011: > > Hi, thanks a lot for your ideas. But

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

2011-06-02 Thread Robert Haas
On Thu, Jun 2, 2011 at 11:17 AM, HuangQi wrote: > Hi, thanks a lot for your ideas. But I've done all these things. I've > checked the gram.y and kwlist.h files many times but can not find what's > wrong. So is there any possibility that the problem comes from something > after parser, though it se

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

2011-06-02 Thread Alvaro Herrera
Excerpts from HuangQi's message of jue jun 02 11:17:21 -0400 2011: > Hi, thanks a lot for your ideas. But I've done all these things. I've > checked the gram.y and kwlist.h files many times but can not find what's > wrong. So is there any possibility that the problem comes from something > after pa

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

2011-06-02 Thread HuangQi
Hi, thanks a lot for your ideas. But I've done all these things. I've checked the gram.y and kwlist.h files many times but can not find what's wrong. So is there any possibility that the problem comes from something after parser, though it seems it should comes from parser? On 2 June 2011 21:14, H

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

2011-06-02 Thread Heikki Linnakangas
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 in

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

2011-06-02 Thread Andrew Dunstan
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 wa

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

2011-06-02 Thread Pavel Stehule
Hello 2011/6/2 HuangQi : > Yes, I've also added mergejoin to kwlist.h as unreserved_keyword. In order > to build AST, I also keep a new node struct in planoperators.h and a new > node tag inside nodes.h. > then recheck alphabet order of keywords, else recheck bison rules. Pavel > On 2 June 201

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

2011-06-02 Thread HuangQi
Yes, I've also added mergejoin to kwlist.h as unreserved_keyword. In order to build AST, I also keep a new node struct in planoperators.h and a new node tag inside nodes.h. On 2 June 2011 15:49, Pavel Stehule wrote: > Hello > > you should to add new keywords to > postgresql/src/include/parser/kw

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

2011-06-02 Thread Pavel Stehule
Hello you should to add new keywords to postgresql/src/include/parser/kwlist.h (depends on pg version) attention - keywords must be in alphabet order Regards Pavel Stehule 2011/6/2 HuangQi : > Hi, >     I'm doing a hacking project which hacks the gram.y file and some other > so that postgres c

[HACKERS] Hacking gram.y Error syntax error at or near "MERGEJOIN"

2011-06-02 Thread HuangQi
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 key