Re: ALTER EXTENSION UPGRADE patch v1

David Fetter <david(at)fetter(dot)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