Usability tweaks for extension commands

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Usability tweaks for extension commands
Date: 2011-02-16 01:18:00
Message-ID: 16871.1297819080@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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?

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.

Thoughts?

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-02-16 01:44:51 Re: updated patch for foreach stmt
Previous Message Josh Berkus 2011-02-16 00:17:56 Re: FOR KEY LOCK foreign keys