Re: Should duplicate indexes on same column and same table

From: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
To: Lista Postgres <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Should duplicate indexes on same column and same table
Date: 2006-12-09 19:45:25
Message-ID: 1165693525.5012.3.camel@debian
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
クルズ クリスチアン ダニエル

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Broersma Jr 2006-12-09 20:04:00 Re: Advice on loading celko sql script
Previous Message Rajesh Kumar Mallah 2006-12-09 19:17:04 Re: Should duplicate indexes on same column and same table be allowed?