Re: Announcing LedgerSMB 1.3.10

[Philip Rhoades <..hidden..>]

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..