Re: LSMB 1.3.5 and PostgreSQL 9.1

[Chris Travers <..hidden..>]

Hi;

On Mon, Nov 21, 2011 at 4:24 PM, Roderick A. Anderson
<..hidden..> wrote:
> 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.

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

This is 1.3.5 or current svn?  I am pretty sure I just committed the
changes which cause those notices yesterday....  (If so you are
probably essentially at 1.3.6 instead.)

Those notices are normal and expected.  I added DROP TYPE IF EXISTS
and a DROP FUNCTION IF EXISTS to more smoothly handle upgrades within
the stable 1.3 branch.


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

I believe pg_trgm.sql dependencies were removed.  tsearch2.sql is only
required if using Pg 8.2.  For future versions of LedgerSMB it too is
removed from the dependencies (and actually 1.4 already has changes in
it to remove the need for tablefunc).

The CREATE EXTENSION should be loading the tablefunc.sql.  If it is
not, and if you are getting errors regarding tablefunc.sql, please let
us know so we can fix them.

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

9.1 moved from the contrib system to an extension system for managing
this sort of behavior.  Create extension is supposed load the proper
packages etc. for you.

Best Wishes,
Chris Travers