안녕하세여?
여러개의 테이블이 잇는데 그중 문제를 발생하는 테이블만 짤랐습니다.
create sequence development_state_seq;
create table development_state(
development_state_code int DEFAULT nextval('development_state_seq') UNIQUE NOT NULL,
development_state_korean varchar(50) UNIQUE,
development_state_english varchar(50) UNIQUE NOT NULL
);
psql:aaa.sql:25: NOTICE: CREATE TABLE/UNIQUE will create implicit index 'development_s_development_s_key' for table 'development_state'
psql:aaa.sql:25: NOTICE: CREATE TABLE/UNIQUE will create implicit index 'development_s_development_s_key' for table 'development_state'
psql:aaa.sql:25: NOTICE: CREATE TABLE/UNIQUE will create implicit index 'development_s_development_s_key' for table 'development_state'
psql:aaa.sql:25: ERROR: Cannot create index: 'development_s_development_s_key' already exists
|