Re: RPM 1.3.10

On Sun, Jan 29, 2012 at 12:42 PM, Philip Rhoades <..hidden..> 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 <..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?

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

--
Philip Rhoades

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

------------------------------------------------------------------------------

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
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel