Re: redundants indexes can be created

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Richard Huxton <dev(at)archonet(dot)com>, Cyril SCETBON <scetbon(at)echo(dot)fr>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: redundants indexes can be created
Date: 2008-07-04 13:33:41
Message-ID: 76D3950ED8DF525220B9D529@imhotep.credativ.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

--On Freitag, Juli 04, 2008 11:26:31 +0100 Richard Huxton
<dev(at)archonet(dot)com> wrote:

> 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?

And what would characterize a "duplicate" index? Think about partial
indexes, where we actually _want_ to have multiple indexes for certain
ranges on the same column.

--
Thanks

Bernd

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Cyril SCETBON 2008-07-04 13:57:08 Re: redundants indexes can be created
Previous Message Magnus Hagander 2008-07-04 10:27:07 Re: [GENERAL] pg crashing