Re: Extensions versus pg_upgrade

"David E. Wheeler" <david@kineticode.com> writes:
> On Feb 8, 2011, at 10:03 AM, Robert Haas wrote:
>> No, this is not doable, or at least not in a way that provides any
>> benefit over just dropping and reinstalling.  The problem is that it
>> is going to fall down all over the place if other objects are
>> depending on objects provided by the extension.  Like:
>> 
>> CREATE VIEW v AS SELECT extensionfunc(1);

> Ah, right, of course. I don't suppose CREATE OR REPLACE would work, either, in some cases at least?

But figuring out just what commands to issue is pretty nearly AI-complete.
The whole point of ALTER EXTENSION UPGRADE is to have a human do that
and then give you a script to run.
        regards, tom lane