On Wed, Feb 1, 2012 at 8:52 AM, Chris Travers <chris.travers@xxxxxxxxx> wrote: > Hi all; > > We have gotten a report from a user who is having issues with CREATE > EXTENSION tablefunc. I figured I would ask for additional insight and > assistance at this point. > > When the user tries to run CREATE EXTENSION tablefunc; the following occurs: > > -bash-4.2$ dropdb ext_test > -bash-4.2$ createdb ext_test > -bash-4.2$ psql ext_test > psql (9.1.2) > Type "help" for help. > > ext_test=# select version(); > version > ------------------------------------------------------------------------------------------------------------- > PostgreSQL 9.1.2 on x86_64-redhat-linux-gnu, compiled by gcc (GCC) > 4.6.2 20111027 (Red Hat 4.6.2-1), 64-bit > (1 row) > > ext_test=# CREATE EXTENSION tablefunc; > ERROR: type "tablefunc_crosstab_2" already exists > > This lead me to conclude that we needed to CREATE EXTENSION FROM UNPACKAGED > thinking this might be an upgrade issue. However no luck. > > ext_test=# CREATE EXTENSION tablefunc FROM unpackaged; > ERROR: function normal_rand(integer, double precision, double > precision) does not exist > > > What should be tried next? by any chance did you create the extension in the template1 database? merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
