Re: Let's drop two obsolete features which are bear-traps for novices - Mailing list pgsql-hackers

On 2014-11-01 14:19:22 -0400, Andrew Dunstan wrote:
> Isn't the planner still going to try to use the index in that case? If it's
> not then I'd be OK with it, but if it's going to make the table largely
> unusable until it's reindexed that would be rather sad.

Both the planner (for querying) and the executor (to avoid inserting
tuples into the index) would have to query the state of such indexes. I
don't think it can reasonably work otherwise.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services