Should duplicate indexes on same column and same table be allowed?

From: "Rajesh Kumar Mallah" <mallah(dot)rajesh(at)gmail(dot)com>
To: "Lista Postgres" <pgsql-admin(at)postgresql(dot)org>
Subject: Should duplicate indexes on same column and same table be allowed?
Date: 2006-12-09 06:03:57
Message-ID: a97c77030612082203j5b1dac19i96ef9932d60f375e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Some of our tables have duplicate indexes on same column by different
index names.
Should the database server check for the existance of (effectively)
same index in
a table before creating a new one.

Regds
Mallah.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-12-09 06:56:11 Re: Should duplicate indexes on same column and same table be allowed?
Previous Message Andy Shellam (Mailing Lists) 2006-12-09 01:49:38 Re: .bat file to access postgreSQL command line from C:\