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
