On Feb 15, 2011, at 5:18 PM, Tom Lane wrote: > Currently, ALTER EXTENSION UPDATE throws an error if there's nothing to > do: > > regression=# create extension adminpack ; > CREATE EXTENSION > regression=# alter extension adminpack update; > ERROR: version to install or update to must be different from old version > > On reflection it seems like this is overly paranoid, and it'd be more > useful if the ALTER just reported a NOTICE along the lines of "version > so-and-so is already installed". Any objections?
Makes sense to me. > Another thought is that it'd probably be useful for there to be a > "CREATE OR REPLACE EXTENSION" syntax, with the behavior of "install the > extension if it's not present, else make sure it's of the specified or > default version"; this behavior parallels CREATE OR REPLACE LANGUAGE > which is something we've been refining for awhile. I am not however > entirely sure what to do with the SCHEMA option if the extension already > exists --- we might be able to do SET SCHEMA, but perhaps that's too > aggressive. This one is a bit over my head, alas. David -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers