Re: 42883:ERROR function does not exist

[apallik <..hidden..>]

Chris Travers-5 wrote
> 
> On Thu, Apr 5, 2012 at 12:10 PM, apallik <apallik@> 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? 

Finally, I am not sure what the statement 
#postgres 9.1 this is done by create extension pg_trgm btree_gist ..

means, do I have to change something because I have postgres 9.1.3?



--
View this message in context: http://ledger-smb.1045705.n5.nabble.com/42883-ERROR-expected-1-3-12-error-tp5556135p5622367.html
Sent from the Ledger SMB - Users mailing list archive at Nabble.com.

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