Hi,
I propose to append an error message when index name and table name are
same.
example:
postgres@postgres=# create table t (a int not null, constraint t primary
key (a));
ERROR: relation "t" already exists
End users will confusing pretty, because if users meet this message,
users will check pg_class,
but they will not found in pg_class.
in this case,
"index name must not be same relation name" error message is better.
Some RDBMS are allow that table name and constraint unique, primary key
name are same.
if they meet that message(relation "t" already exists), that message is
not clear.
Regards, Ioseph