pg can create duplicated index without any errors even warnning - Mailing list pgsql-hackers

From Alex
Subject pg can create duplicated index without any errors even warnning
Date
Msg-id CAKU4AWqYFmSzqusDiwaFDntP8LGRXSROC4NJaMA4vY6rTvLeJg@mail.gmail.com
Whole thread Raw
Responses Re: pg can create duplicated index without any errors even warnning  (Peter Geoghegan <pg@bowt.ie>)
Re: pg can create duplicated index without any errors even warnning  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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
postgres=# \d t
                 Table "demo.t"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 a      | integer |           |          |
 b      | integer |           |          |
Indexes:
    "m" btree (a)
    "m2" btree (a)


is this by design?  

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Ought to use heap_multi_insert() for pg_attribute/dependinsertions?
Next
From: Amit Langote
Date:
Subject: Re: Problem with default partition pruning