Re: ALTER EXTENSION UPGRADE, v3

Robert Haas <robertmhaas@gmail.com> writes:
> On Thu, Feb 3, 2011 at 1:10 PM, David E. Wheeler <david@kineticode.com> wrote:
>> On Feb 3, 2011, at 10:07 AM, Tom Lane wrote:
>>> Well, pg_upgrade is designed to work within a major-version series, eg
>>> you could do a 9.1-to-9.1 upgrade if you needed to install a newer
>>> version of an extension. �Admittedly, this is swinging a rather larger
>>> hammer than "apply an upgrade script" would entail.

>> Dude. That's a frigging piledriver!

> That's putting it mildly.  It's more like sending a rocket into outer
> space to tweak the orbit of a comet so that it crashes into your
> barbecue grill to light a fire so you can roast marshmallows.

No, it's more like using a sledgehammer to swat a fly because you don't
have a flyswatter and aren't inclined to drive ten miles to buy one.
It'll get the job done, and the added cost of building/maintaining a
more finely calibrated tool may well outweigh the value.
        regards, tom lane