Horton

Re: ALTER EXTENSION UPGRADE, v3

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Robert Haas <robertmhaas@gmail.com>
Cc: "David E. Wheeler" <david@kineticode.com>, Florian Pflug <fgp@phlo.org>, Dimitri Fontaine <dimitri@2ndquadrant.fr>, "Ross J. Reedstrom" <reedstrm@rice.edu>, Anssi Kääriäinen <anssi.kaariainen@thl.fi>, Itagaki Takahiro <itagaki.takahiro@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-02-03T19:02:18Z
Lists: pgsql-hackers 
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