This postgresql query throws error: Error: syntax error at or near "AS"

[Kreijstal]

This is the query:

CREATE SEQUENCE public.user_permissions_id_seq
    AS integer
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

This was generated from pg_dump, so there must be a bug with the library.

[lfittl]

This is likely since this library wasn't updated yet for Postgres 10 - @zhm should be able to comment on how complex of an effort that would be.

It essentially requires an update of the underlying libpg_query library to 10-1.0.0 or newer (see https://github.com/lfittl/libpg_query/blob/10-latest/CHANGELOG.md#10-100---2017-10-30)

[Kreijstal]

this project hasn't been updated in years, tho 😢