Skip to content

Duplicate id Primary Key in Migration #65

@jolonf

Description

@jolonf

I created a new table, and not realising an id column is already created, created a new id column and selected primary key. After realising my error I deleted the id column I just created but in the migration it still had both id columns in the Primary Key:

CREATE TABLE art (
    id UUID DEFAULT uuid_generate_v4() NOT NULL,
    PRIMARY KEY(id, id)
);

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions