Chris,
> [8]> wrote:
>
>> Chris,
>>
>> On
2012-02-01 14 [1]:02, Chris Travers wrote:
>>
>>> On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades
>> > [6]> wrote:
>> >
>> >> Chris,
>>
>>>>
>> >> On 2012-02-01 13 [3] [1]:21, Chris Travers wrote:
>> >> > Hi Philip;
>> >> >
>> >> > Something is obviously not as expected here. 1.3.10
>> addresses
>> >> issues
>> >> > of missing extensions directories by detecting the PostgreSQL
>> >> server
>> >> > version and if it is 9.0 or lower, it tries to look for the
>> >> > tablefunc.sql, but if it is 9.1 or above, it looks for
>> >> > tablefunc.control. If you are running 9.1, and it is still
>> >> doing
>> >> > this, then something isnt right. Either you arent pointing
>> to
>> >> the
>> >>
>> >>> place where tablefunc.control is located, or something else is
>> >> going
>> >> > on.
>> >> >
>> >> > I will be responding to the database troubleshooting steps on
>> the
>> >> > other thread on -devel.
>> >>
>> >> I was doing the RPM testing on a Fedora 16 i686 virtual machine
>> but
>> >> after those issues were resolved, I moved on to a real install
>> on
>> >> my
>> >> live F16 x86_64 which I really need to get going now . .
>> >
>> > Try:
>> >
>> > select version();
>> >
>> > and
>> >
>> > if 9.1:
>> >
>> > CREATE EXTENSION tablefunc;
>> >
>> > do that in a new database.
>> >
>> > If that works you can drop the database and I will send you some
>> > lines
>> > to comment out.
>>
>> -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
>
> Interesting.
>
> Is it possible that tablefunc had been loaded into template1 and then
> this was upgraded?
the transition from Fedora 14 (Postgresql 8.x?) the data was dumped out
and imported into Fedora 16.
> If so, you will need to try this (first on ext_test, and then if
> successful on template1):
>
> CREATE EXTENSION tablefunc FROM unpackaged;
ext_test=# CREATE EXTENSION tablefunc FROM unpackaged;
ERROR: function normal_rand(integer, double precision, double
precision) does not exist
Something in your PostgreSQL database setup is messed up. I am going to suggest we take this up on the Pgsql lists because someone may have a better idea than me (if it were me I would add dummy functions for all those missing and then drop the extension. I will be sending an email there.