Postgresql parsing fail on function body: no viable alternative at input

Question

Postgresql parsing fail on function body: no viable alternative at input

Opened this issue a year ago · 2 comments

Hello,

Thanks for this PR #416

I've noticed the parser is not working on function like this:

CREATE FUNCTION public.myfunction() RETURNS void
    LANGUAGE sql
    AS $$
        -- Do something
    $$;

with the output being:

Error: no viable alternative at input '$$\n\t-- Do something\n            $$;\n'

Regards.

Answer 1 · 2023-09-07T10:33:10.000Z

As a workaround, I use this simple sed command to remove the functions from the sql dump sed '/CREATE FUNCTION/,/\$\$;/d' input.sql > output.sql

Answer 2 · 2023-09-07T11:51:37.000Z

Hi mermetbt,

Thanks for the workaround. Indeed the new postgres grammar introduce in #416 even though more complete than our previous parser, it's still not perfect. We'll try to improve this in the future.