Re: pg can create duplicated index without any errors even warnning

Alex <zhihui.fan1213@gmail.com> writes:
> postgres=# create table t (a int, b int);
> CREATE TABLE
> postgres=# create index m on t(a);
> CREATE INDEX
> postgres=# create index m2 on t(a);
> CREATE INDEX

> is this by design?

Yes.

            regards, tom lane