Re: Should duplicate indexes on same column and same table - Mailing list pgsql-admin

From Daniel Cristian Cruz
Subject Re: Should duplicate indexes on same column and same table
Date
Msg-id 1165693525.5012.3.camel@debian
Whole thread Raw
In response to Re: Should duplicate indexes on same column and same table be allowed?  ("Rajesh Kumar Mallah" <mallah.rajesh@gmail.com>)
List pgsql-admin
Em Dom, 2006-12-10 às 00:47 +0530, Rajesh Kumar Mallah escreveu:
> psql> CREATE INDEX x on test (col1);
> psql> CREATE INDEX y on test (col1);
>
> What is (are) the downsides of disallowing the
> second index. which is *exactly* same as
> previous?

What if PostgreSQL make a NOTICE about this? The user could see it and
take some action about it.

Sincerely,
--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル


pgsql-admin by date:

Previous
From: "Rajesh Kumar Mallah"
Date:
Subject: Re: Should duplicate indexes on same column and same table be allowed?
Next
From: Richard Broersma Jr
Date:
Subject: Re: Advice on loading celko sql script