Re: ALTER EXTENSION ... UPGRADE;

David Wheeler <david@kineticode.com>

From: "David E. Wheeler" <david@kineticode.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Dimitri Fontaine <dimitri@2ndQuadrant.fr>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2010-12-11T00:17:55Z

Lists: pgsql-hackers

On Dec 10, 2010, at 4:15 PM, Tom Lane wrote:

>> Huh? It's in the pg_extension catalog.
> 
> How do you select which upgrade script to apply?

You run all those that contain version numbers higher than the currently-installed one.

This of course assumes that one can correctly tell that one version number is higher than another.

Best,

David