Re: ALTER EXTENSION ... UPGRADE; - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: ALTER EXTENSION ... UPGRADE;
Date
Msg-id 7D03324B-AC7E-4084-9EF9-D4BC0D21AB55@kineticode.com
Whole thread Raw
In response to Re: ALTER EXTENSION ... UPGRADE;  (Dimitri Fontaine <dimitri@2ndQuadrant.fr>)
Responses Re: ALTER EXTENSION ... UPGRADE;  (Aidan Van Dyk <aidan@highrise.ca>)
List pgsql-hackers
On Dec 11, 2010, at 12:09 PM, Dimitri Fontaine wrote:

> Yeah that works, as soon as VVV is the version we upgrade from.
>
> That said, we need to find a way to lighten the process for extensions
> where it's easy to have a single script to support upgrade from more
> than once past release.
>
> What about having the following keys supported in the control file:
>
>  upgrade_<version> = 'script.version.sql'
>  upgrade_all = 'script.sql'

Why not just use an upgrade script naming convention? Think: Convention over configuration.

> Where the version here is the version you're upgrading *from* (to is
> known and static when you distribute the files after all), and where
> upgrade_all is applied last no matter what got applied before.
>
> Also, do we want a subdirectory per extension to host all those files?

How are things currently arranged?

Best,

David




pgsql-hackers by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: Extensions, patch v16
Next
From: Jim Nasby
Date:
Subject: Re: would hw acceleration help postgres (databases in general) ?