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