Re: syntax for drop if exists

Tom Lane wrote:

>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>The MySQL syntax is actually "drop table if exists foo ...".
>>Implementing this unfortunately generates a shift/reduce conflict,
>>
>>
>
>What did you try exactly? I don't see any fundamental reason for
>a conflict here. You may just need to rearrange the grammar to postpone
>the reduction a bit.
>
>
>

You're right, as usual. I had factored out the IF EXISTS bit into a
seperate rule. When I undid that and instead used 2 rules for DropStmt,
the problem disappeared. (This is because it gives bison more info about
the context of each IF - this has often caught me with bison - I should
have known better).

cheers

andrew