Chris,
On 2012-01-30 11:45, Chris Travers wrote: > On Sun, Jan 29, 2012 at 12:42 PM, Philip Rhoades <[email protected] > [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 >> <[email protected] [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: [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
