"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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 9 of 33 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedFeb 8, '11 at 4:54p
activeFeb 10, '11 at 4:59p
posts33
users5
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase