On 12/13/16 1:15 AM, Ioseph Kim wrote: > 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
The code to detect that would probably be fairly complicated for such a rare case. A more principled approach might be to create an error context for the index creation so that you can tell what is going on when the error happens. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers