thin-backend icon indicating copy to clipboard operation
thin-backend copied to clipboard

Duplicate id Primary Key in Migration

Open jolonf opened this issue 3 years ago • 0 comments

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)
);

jolonf avatar Oct 02 '22 22:10 jolonf