Re: extensions in 9.1

On Tue, 20 Sep 2011 11:36:15 -0400,
Tom Lane  wrote:

> Seb  writes:
>> I'm starting to migrate to 9.1 and see that there's a new mechanism
>> to install extensions via de "CREATE EXTENSION" command.  It seems
>> very simple and convenient, but with "CREATE EXTENSION tablefunc" I'm
>> getting the error:

>> ERROR: function "normal_rand" already exists with same argument types

> It sounds like you already have the old "unpackaged" version of that
> module installed.  You need to do a one-time conversion to get from
> that state to having the objects wrapped in an extension.  For the
> standard contrib modules that's done with "CREATE EXTENSION ... FROM
> unpackaged".

How can I check if this is the case?  I was getting that same error when
trying to install the adminpack onto the postgres database (as postgres
user of course).  If I try "CREATE EXTENSION adminpack FROM unpackaged"
onto the postgres database this way, I get:

ERROR:  extension "adminpack" has no update path from version "unpackaged" to version "1.0"

and "CREATE EXTENSION tablefunc FROM unpackaged" onto the template1
database, I get:

ERROR:  function normal_rand(integer, double precision, double precision) does not exist


-- 
Seb