Re: Announcing LedgerSMB 1.3.10

On Tue, Jan 31, 2012 at 7:29 PM, Philip Rhoades <..hidden..> wrote:

Chris,

On 2012-02-01 14:02, Chris Travers wrote:

> On Tue, Jan 31, 2012 at 6:55 PM, Philip Rhoades <..hidden..

> [6]> wrote:
>
>> Chris,

>>
>> On 2012-02-01 13 [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?

If so, you will need to try this (first on ext_test, and then if successful on template1):

CREATE EXTENSION tablefunc FROM unpackaged;

DROP EXTENSION tablefunc;

If that seems to work, repeat the create extension test before repeating the two commands above in template1.

Best Wishes,

Chris Travers

- same as before . .

Thanks,

Phil.
--
Philip Rhoades

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

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users