Re: 42883:ERROR function does not exist

[Chris Travers <..hidden..>]

On Fri, Apr 6, 2012 at 1:58 AM, apallik <..hidden..> wrote:
>
> Chris Travers-5 wrote
>>
>> On Thu, Apr 5, 2012 at 12:10 PM, apallik &lt;apallik@&gt; wrote:
>>
>>>
>>>
>>> Just looked through the error log file again and the apache log files and
>>> it
>>> turns out that the problem occurs with psql command not found. Even
>>> though
>>> when I do echo$ PATH is see that my path is set correctly and when I call
>>> psql from terminal it responds, it seems not to identify the command when
>>> called through the Database.pm file that creates the new database. Hope
>>> this
>>> helps
>>>
>> It does.
>>
>> Try setting PATH variables in your ledgersmb.conf.
>>
>> Best Wishes,
>> Chris Travers
>>
>> ------------------------------------------------------------------------------
>> For Developers, A Lot Can Happen In A Second.
>> Boundary is the first to Know...and Tell You.
>> Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
>> http://p.sf.net/sfu/Boundary-d2dvs2
>> _______________________________________________
>> Ledger-smb-users mailing list
>> ..hidden..
>> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>>
>
> Ok this worked but now I am getting some other error messages and notices.
> I'll start with the error messages and try to fix those
>
> /Library/PostgreSQL/9.1/share/postgresql/extension/pg_trgm.sql: No such file
> or directory/Library/PostgreSQL/9.1/share/postgresql/extension/tsearch2.sql:
> No such file or directory
> /Library/PostgreSQL/9.1/share/postgresql/extension/tablefunc.sql: No such
> file or directory
>
> When I look in the specific directory (.../extension/) I do have all these
> files but as pg_trgm--1.0.spl (similar for other files). When I look in the
> Database.pm I have
>
>
>  my @contrib_scripts = qw(pg_trgm tsearch2 tablefunc);
>    if($ENV{PG_CONTRIB_DIR})
>    {
>     #postgres 9.1 this is done by create extension pg_trgm btree_gist ..
>     for my $contrib (@contrib_scripts){
>         $rc2=system("psql -f $ENV{PG_CONTRIB_DIR}/$contrib.sql >>
> $temp/dblog_stdout 2>>$temp/dblog_stderr");
>
>
> Is that the problem, eg pg_trgm not being pg_trgm--1.0 ? Also, I have
> .control files in the same directory (eg pg_trgm.control). I have also been
> looking for the contrib.sql in the same directory but cannot find it, is
> this somewhere else?
>
These are harmless.  We use CREATE EXTENSION in the Pg-database.sql to
prevent this from being a problem.

Best Wishes,
Chris Travers

------------------------------------------------------------------------------
For Developers, A Lot Can Happen In A Second.
Boundary is the first to Know...and Tell You.
Monitor Your Applications in Ultra-Fine Resolution. Try it FREE!
http://p.sf.net/sfu/Boundary-d2dvs2
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users