분명 인덱스는 없는데, 인덱스를 만들려고 하니 에러가 나는데요.
왜그런지요.
<Class Name>
t_char_info
<Attributes>
char_name CHARACTER(50) NOT NULL
login_info INTEGER
login_time TIMESTAMP
<Constraints>
UNIQUE u_t_char_info_char_name ON t_char_info (char_name)
Current transaction has been committed.
sqlx> create index on t_char_info(char_name)
sqlx> ;x
In the command from line 1,
ERROR: Index \"u_t_char_info_char_name\" already defined for class \"t_char_info\".
|