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
