"Sebastian P. Luque" <spluque@xxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
