[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Announcing LedgerSMB 1.3.10



Chris,


On 2012-02-01 17:32, Chris Travers wrote:
On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades <..hidden..
[8]> wrote:

Chris,

On 2012-02-01 14 [1]:02, Chris Travers wrote:

On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades
<..hidden.. [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

Thanks,

Phil.
--
Philip Rhoades

GPO Box 3411
Sydney NSW	2001
Australia
E-mail:  ..hidden..