LSMB 1.3.5 and PostgreSQL 9.1

["Roderick A. Anderson" <..hidden..>]

I'm doing a semi-automated installation and have run into some problems 
trying to create a new company database.

This is a fresh(-ish) install into a Linux-Vserver guest running CentOS 
5.7.  I've installed Perl 5.14.2 using perlbrew and had no problems I 
didn't cause myself.  The PostgreSQL RPMS were installed from pgrpms.org.

But when I ran prepare-company-database.sh (and after working around 
some other self-inflicted Pg problems) I run into this.

..hidden.. 1.3]# ./tools/prepare-company-database.sh --company aesoft 
--pgsql-contrib /usr/pgsql-9.1/share/extension/ --host 192.168.3.177
cat: /usr/pgsql-9.1/share/extension//tsearch2.sql: No such file or directory
cat: /usr/pgsql-9.1/share/extension//pg_trgm.sql: No such file or directory
cat: /usr/pgsql-9.1/share/extension//tablefunc.sql: No such file or 
directory
CREATE EXTENSION
NOTICE:  type "eca__pricematrix" does not exist, skipping
DROP TYPE
NOTICE:  type "company_search_result" does not exist, skipping
DROP TYPE
NOTICE:  type "eca_history_result" does not exist, skipping
DROP TYPE
NOTICE:  type "entity_credit_search_return" does not exist, skipping
DROP TYPE
NOTICE:  type "entity_credit_retrieve" does not exist, skipping
DROP TYPE
NOTICE:  type "company_billing_info" does not exist, skipping
DROP TYPE
NOTICE:  function 
company_save(pg_catalog.int4,text,pg_catalog.int4,text,text,pg_catalog.int4,text,pg_catalog.int4) 
does not exist, skipping

I'm concerned about tsearch2.sql, pg_tram.sql, and table_func.sql errors.

The directory /usr/pgsql-9.1/share/extension/ has these files.

-rw-r--r-- 1 root root  4839 Sep 23 02:26 pg_trgm--1.0.sql
-rw-r--r-- 1 root root   177 Sep 23 02:26 pg_trgm.control
-rw-r--r-- 1 root root  4092 Sep 23 02:26 pg_trgm--unpackaged--1.0.sql
...
-rw-r--r-- 1 root root 15573 Sep 23 02:26 tsearch2--1.0.sql
-rw-r--r-- 1 root root   313 Sep 23 02:26 tsearch2.control
-rw-r--r-- 1 root root  8951 Sep 23 02:26 tsearch2--unpackaged--1.0.sql
...
-rw-r--r-- 1 root root  2013 Sep 23 02:26 tablefunc--1.0.sql
-rw-r--r-- 1 root root   174 Sep 23 02:26 tablefunc.control
-rw-r--r-- 1 root root  1004 Sep 23 02:26 tablefunc--unpackaged--1.0.sql

Are these the new naming conventions?


\\||/
Rod
--