Skip to content

Partition by not supported - postgre #1281

Closed
@danyatheslayer

Description

@danyatheslayer

Have this query:

CREATE TABLE measurement (
    city_id         int not null,
    logdate         date not null,
    peaktemp        int,
    unitsales       int
) PARTITION BY RANGE (logdate);

Got this error:
sql parser error: Expected end of statement, found: PARTITION at Line: 7, Column 7
Doc:
https://www.postgresql.org/docs/current/ddl-partitioning.html

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions