"David E. Wheeler" <[email protected]> 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?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);
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
