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?

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

Reply via email to