Re: extensions in 9.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Seb <spluque(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: extensions in 9.1
Date: 2011-09-20 15:36:15
Message-ID: 8653.1316532975@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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".

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian P. Luque 2011-09-20 15:58:00 Re: extensions in 9.1
Previous Message Andreas Kretschmer 2011-09-20 15:20:55 Re: Seeing foreign key lookups in explain output