Skip to content

Error: unknown PostgreSQL type: ltree #377

@dharmjit

Description

@dharmjit

In DB schema I have ltree extension

CREATE TABLE IF NOT EXISTS groups (
    id SERIAL PRIMARY KEY,
    name VARCHAR NOT NULL,
    fully_qualified_name ltree,
    scopes TEXT [],
    parent_id INTEGER REFERENCES groups (id),
    created_by VARCHAR REFERENCES users (username),
    created_on TIMESTAMP DEFAULT NOW()
);

and sqlc generate below error

2020/03/05 02:51:09 unknown PostgreSQL type: ltree

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions