digitallyinduced/thin-backend

Duplicate id Primary Key in Migration

jolonf opened this issue · 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)
);