Re: extensions in 9.1

On Tue, 20 Sep 2011 11:36:15 -0400,
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Seb <spluque(at)gmail(dot)com> 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