redundants indexes can be created - Mailing list pgsql-general

From Cyril SCETBON
Subject redundants indexes can be created
Date
Msg-id 486DF35D.70603@echo.fr
Whole thread Raw
Responses Re: redundants indexes can be created
Re: redundants indexes can be created
List pgsql-general
Hi guys,

Why postgres does not disallow creating redundants indexes ? Is it the
same behaviour in postgresql 8.3 ?

postgres=# \d t1
             Table "public.t1"
Column |         Type          | Modifiers
--------+-----------------------+-----------
id     | integer               | not null
name   | character varying(20) |
Indexes:
    "t1_pkey" PRIMARY KEY, btree (id)
    "idx" btree (id)
    "idx2" btree (id)
    "idx3" btree (id)
    "idx4" btree (id)
    "idx5" btree (id)


Regards
--
Cyril SCETBON


pgsql-general by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: php + postgresql website ?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: redundants indexes can be created