On Tue, 20 Sep 2011 11:36:15 -0400, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Seb <spluque@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
