Re: Partial indices

Added to TODO:

* Re-enable partial indexes

> Mike Mascari <mascarm(at)mascari(dot)com> writes:
> >> Are Partial Indices still supported into latest release of PostgreSQL?
>
> > I think they have suffered some serious bit-rot over the years
> > and are no longer functional, although some of the core code
> > still exists in the backend.
>
> Actually, quite a LOT of partial-index support code still exists in the
> backend. Someone removed support for the "WHERE predicate" clause of
> CREATE INDEX from the grammar, but I don't know when or why that was
> done. AFAICT everything is still there to support the feature
> downstream, and it doesn't look particularly bit-rotted.
>
> Someday when we don't have any more-pressing problems, I'd like to try
> to re-enable that support. At the very least I might learn why it
> was disabled ;-)
>
> (Hey Bruce, do we have a TODO item for "Fix partial indices"?)
>
> regards, tom lane
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026