Disable duplicate index creation

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: Disable duplicate index creation
Date: 2007-06-14 15:10:44
Message-ID: f4rlpq$21j5$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gary Fu 2007-06-14 15:12:02 allocate chunk of sequence
Previous Message Scott Marlowe 2007-06-14 14:57:56 Re: DeadLocks...