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

-- 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general