pq: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\"

Viewed 2263

I am trying to run some postgres sql 11 migrations which involves creation of tables if it doesn't exist inside of a docker container using goose of golang.

Below is the sql script

CREATE TABLE IF NOT EXISTS identity.mytable (
    id bigint NOT NULL,
    name text,
    CONSTRAINT mytable_pk PRIMARY KEY (id)
);

I am sure that the table is not being manipulated by any other process except this so not sure why I get this error.

pq: duplicate key value violates unique constraint \"pg_type_typname_nsp_index\"

is it possible that the schema name, I am trying to use is identity which is a reserved keyword?

0 Answers
Related