pg can create duplicated index without any errors even warnning

From: Alex <zhihui(dot)fan1213(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: pg can create duplicated index without any errors even warnning
Date: 2019-08-06 02:34:19
Message-ID: CAKU4AWqYFmSzqusDiwaFDntP8LGRXSROC4NJaMA4vY6rTvLeJg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2019-08-06 02:49:47 Re: Problem with default partition pruning
Previous Message Michael Paquier 2019-08-06 02:24:46 Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions?