Re: redundants indexes can be created

Cyril SCETBON wrote:
> Richard Huxton wrote:
>> Cyril SCETBON wrote:
>>> Hi guys,
>>>
>>> Why postgres does not disallow creating redundants indexes ? Is it the
>>> same behaviour in postgresql 8.3 ?
>>
>> Why should it stop you?
>> Do you have an application that randomly generates indexes?
> I'm just wondering why postgresql/mysql work like that.

You ask for a particular index, it creates the index. Why complicate the
code checking for possible duplicate indexes if it's not a problem
people tend to encounter?

--
   Richard Huxton
   Archonet Ltd