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

Re: Announcing LedgerSMB 1.3.10



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

- same as before . .

Thanks,

Phil.
--
Philip Rhoades

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