Re: ALTER EXTENSION UPGRADE, v3

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>
To: "David E. Wheeler" <david@kineticode.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, 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-03T18:47:37Z
Lists: pgsql-hackers
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.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company