Is generated always as identity not supported.

[samjay000]

When trying to parse

CREATE TABLE table2
(
    column21 bigint primary key generated always as identity,
    column22 text
);

let ast: Vec<ast::Statement> = SQLParser::parse_sql(&dialect, &contents).unwrap();

dialect = PostgreSqlDialect
contents = above DDL

Will produce

ParserError("Expected ',' or ')' after column definition, found: generated")

Above DDL is valid on PostgreSQL.
Am I doing something wrong or is generated always as identity not supported?

[AugustoFKL]

@sam-mmm that's a constraint not supported yet.

[samjay000]

Thanks,

this pull request covers it #587

[AugustoFKL]

@sam-mmm can't that be reduced to smaller PRs?

Having a huge PR with different concepts makes it hard to review. You're dealing with 3 different problems at least, that could be 3 different PRs.

[samjay000]

@AugustoFKL I have closed PR #587 and created PR #673