On Sun, Jan 29, 2012 at 12:42 PM, Philip Rhoades <[email protected]> wrote:
> 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 <[email protected]
> >> [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?
>
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?
Best Wishes,
Chris Travers
>
> Thanks,
>
> Phil.
> --
> Philip Rhoades
>
> GPO Box 3411
> Sydney NSW 2001
> Australia
> E-mail: [email protected]
>
> --
> Philip Rhoades
>
> GPO Box 3411
> Sydney NSW 2001
> Australia
> E-mail: [email protected]
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Ledger-smb-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
>
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Ledger-smb-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
