Re: Announcing LedgerSMB 1.3.10

[Philip Rhoades <..hidden..>]

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