Re: extensions in 9.1

"Sebastian P. Luque" <spluque(at)gmail(dot)com> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> It sounds like you already have the old "unpackaged" version of that
>> module installed.

> 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

Well, maybe you had better explain the history of this database a bit
better. It seems like you've got a subset of the tablefunc functions
installed; how did that come to be? And how did the adminpack functions
get in there? Checking the archives, the reason we didn't bother with
an "unpackaged" upgrade path for adminpack is that it's always installed
its functions into the pg_catalog schema, meaning pg_dump wouldn't dump
them, so they should not have been there after an upgrade.

regards, tom lane