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

[Tom Lane]

Alex <zhihui.fan1...@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