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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to