Re: RPM 1.3.10

[Philip Rhoades <..hidden..>]

Chris,


On 2012-01-30 11:45, Chris Travers wrote:
> On Sun, Jan 29, 2012 at 12:42 PM, Philip Rhoades <..hidden..
> [10]> wrote:
>
> > Chris,
> >
> > On 2012-01-25 01 [1]:30, Philip Rhoades wrote:
> > > Chris,
> > >
> > >
> > > On 2012-01-24 21 [2]:53, Chris Travers wrote:
> > >> On Tue, Jan 24, 2012 at 12:32 AM, Philip Rhoades
> > <..hidden.. [3]
> > >> [2]> wrote:
> > >>
> > >>> Chris,
> > >>>
> > >>> On 2012-01-24 19 [4] [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?
>
> If you try this what happens (as postgres user):
>
> createdb ext_test
> psql ext_test
>
> In psql try the following:
>
> CREATE EXTENSION tablefunc;
> df connectby
>
> What do you get?


ext_test=# CREATE EXTENSION tablefunc;
ERROR:  type "tablefunc_crosstab_2" already exists
ext_test=# \df connectby
                       List of functions
 Schema | Name | Result data type | Argument data types | Type
--------+------+------------------+---------------------+------
(0 rows)


Regards,

Phil.
--
Philip Rhoades

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