[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: RPM 1.3.10



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