Re: ALTER EXTENSION UPGRADE patch v1 - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: ALTER EXTENSION UPGRADE patch v1
Date
Msg-id m2wrmkmpo8.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: ALTER EXTENSION UPGRADE patch v1  (David Fetter <david@fetter.org>)
Responses Re: ALTER EXTENSION UPGRADE patch v1  (David Fetter <david@fetter.org>)
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> Do you plan to have
>
> ALTER EXTENSION ... UPGRADE TO VERSION ...
>
> , or the more general,
>
> ALTER EXTENSION ... ALTER VERSION TO ... ?

Well why not, but I'm not sure I understand what you have in mind here.
I don't exactly see how to install more than one version on the server,
at the filesystem level, with the current infrastructure.

The way debian solves it for multi-versions packages, such as PostgreSQL
for example, is to add the (major) version number in the package name,
so that you have independent packages such as: postgresql-8.3 postgresql-8.4 postgresql-9.0

Are you thinking about doing something similar with extensions? 

The only other way I'm able to think about your request would be for the
command to simply ERROR out when the premises given by the users are not
matching the reality of what's installed both in the catalogs and on the
file system.  If that's what you're talking about, we still can make it
material for 9.1, I believe.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: system views for walsender activity
Next
From: Robert Haas
Date:
Subject: Re: system views for walsender activity