Issue with CREATE EXTENSION tablefuncKreiter

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: Philip Rhoades <phil(at)pricom(dot)com(dot)au>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Issue with CREATE EXTENSION tablefuncKreiter
Date: 2012-02-01 14:52:17
Message-ID: CAKt_ZfsRXYJwky=qVmwBqFG0fMMbcdEKzEAqBeteqZ24J=62gA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Best Wishes,
Chris Travers

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2012-02-01 14:58:16 Re: Issue with CREATE EXTENSION tablefuncKreiter
Previous Message Marti Raudsepp 2012-02-01 14:33:07 Re: parameter "vacuum_defer_cleanup_age"