Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pg can create duplicated index without any errors even warnning
Date
Msg-id 31587.1565069572@sss.pgh.pa.us
Whole thread Raw
In response to pg can create duplicated index without any errors even warnning  (Alex <zhihui.fan1213@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Putting kerberos/ldap logs somewhere useful
Next
From: Tom Lane
Date:
Subject: Re: The unused_oids script should have a reminder to use the 8000-8999 OID range