Re: undead index

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jens Wilke <jens(dot)wilke(at)affinitas(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: undead index
Date: 2011-05-06 16:44:02
Message-ID: 14012.1304700242@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jens Wilke <jens(dot)wilke(at)affinitas(dot)de> writes:
> On Friday 06 May 2011 18:08:58 Tom Lane wrote:
>> There doesn't appear to be any fix for this that doesn't require a time
>> machine and/or a lot more effort than it's worth.

> Isn't it possible to backport the fix for pg_get_indexdef() to 8.* ?

We could install a kluge (not backport the actual change, which was
adding CONCURRENTLY to the set of grammar keywords). But that would
only help people who were trying to update from 8.4.something-after-8.

Now that I think about it, I believe we considered that at the time,
and rejected it on the grounds that the case would come up so seldom as
to not be worth the trouble. I think that's probably still true, and
anyway the value of doing it drops further every day. The time to have
done it would have been a year ago.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2011-05-06 17:02:12 Re: Growing a live database
Previous Message Jens Wilke 2011-05-06 16:22:11 Re: undead index