On Wed, Feb 1, 2012 at 4:40 AM, Philip Rhoades <..hidden..
[9]> wrote:
Chris,
On 2012-02-01 17 [1]:32, Chris Travers wrote:
> On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades
<..hidden.. [2]
> [8]> wrote:
>
>> Chris,
>> On 2012-02-01 14 [3] [1]:02, Chris Travers wrote:
>>
>>> On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades
>> <..hidden.. [4] [2]
>> > [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?
Yes maybe - I had some old unused LSMB DBs (1.2.x?) in my setup and
in
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.