Disable duplicate index creation - Mailing list pgsql-general

From Andrus
Subject Disable duplicate index creation
Date
Msg-id f4rlpq$21j5$1@news.hub.org
Whole thread Raw
Responses Re: Disable duplicate index creation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
PostgreSQL runs commands

create table test ( test integer primary key );
create index i1 on test(test);
create index i2 on test(test);

without any error.
Now there are 3 same indexes on table.

How to fix this so that duplicate indexes are not allowed ?


Andrus.

pgsql-general by date:

Previous
From: Gary Fu
Date:
Subject: allocate chunk of sequence
Next
From: Lza
Date:
Subject: Historical Data Question