Re: RPM 1.3.10

[Philip Rhoades <..hidden..>]

Chris,


On 2012-01-25 01:30, Philip Rhoades wrote:
> Chris,
>
>
> On 2012-01-24 21:53, Chris Travers wrote:
> > On Tue, Jan 24, 2012 at 12:32 AM, Philip Rhoades <..hidden..
> > [2]> wrote:
> >
> > > Chris,
> > >
> > > On 2012-01-24 19 [1]:24, Chris Travers wrote:
> > > > hmmmm..... we may have to rethink the PostgreSQL dependencies in
> > > the
> > > > RPM.....  You need the postgresql-contrib package to be
> > > installed.
> > > >
> > > > Best Wishes,
> > > > Chris Travers
> > >
> > > Installed that and its dependencies but still get the same error.
> >
> > Point the ledgersmb.conf to the directory where tablefunc.sql can be
> > located.
>
>
> tablefunc.sql does not exist for F16 (it was there for F14) - I 
> tried:
>
>    yum provides */tablefunc.sql
>
> with no result . .


postgresql-contrib-9.1.2-2.fc16.x86_64 has the following files (amongst 
others):

  /usr/lib64/pgsql/tablefunc.so
  /usr/share/pgsql/extension/tablefunc--1.0.sql
  /usr/share/pgsql/extension/tablefunc--unpackaged--1.0.sql
  /usr/share/pgsql/extension/tablefunc.control

I tried symlinking the sql files (sequentially) to:

  /usr/share/pgsql/contrib/tablefunc.sql

but I still get the same error running:

  su - postgres -c "psql lsmb_naf < 
/usr/share/ledgersmb/sql/Pg-database.sql"

ie:

ERROR:  function connectby(text, text, text, text, text, integer, text) 
does not exist
LINE 5:   FROM (connectby('menu_node'::text, 'id'::text, 'parent'::t...

Is there a solution to this problem?

Thanks,

Phil.
--
Philip Rhoades

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

--
Philip Rhoades

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