SF.net SVN: ledger-smb:[3789] branches/1.3/sql/Pg-database.sql

[..hidden..]

Revision: 3789
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3789&view=rev
Author:   einhverfr
Date:     2011-10-02 16:58:11 +0000 (Sun, 02 Oct 2011)
Log Message:
-----------
Fixes for Pg-database so it will load on 9.1

Modified Paths:
--------------
    branches/1.3/sql/Pg-database.sql

Modified: branches/1.3/sql/Pg-database.sql
===================================================================
--- branches/1.3/sql/Pg-database.sql	2011-10-02 15:21:46 UTC (rev 3788)
+++ branches/1.3/sql/Pg-database.sql	2011-10-02 16:58:11 UTC (rev 3789)
@@ -1,4 +1,5 @@
 CREATE LANGUAGE PLPGSQL; -- separate transaction since may already exist
+CREATE EXTENSION tablefunc; -- Separate transaction, only needed for 9.1
 
 begin;
 CREATE SEQUENCE id;
@@ -3446,13 +3447,6 @@
 Example: SELECT as_array(ARRAY[id::text, class]) from contact_class
 $$;
 
-CREATE INDEX company_name_gist__idx ON company USING gist(legal_name gist_trgm_ops);
-CREATE INDEX location_address_one_gist__idx ON location USING gist(line_one gist_trgm_ops);
-CREATE INDEX location_address_two_gist__idx ON location USING gist(line_two gist_trgm_ops);
-CREATE INDEX location_address_three_gist__idx ON location USING gist(line_three gist_trgm_ops);
-    
-CREATE INDEX location_city_prov_gist_idx ON location USING gist(city gist_trgm_ops);
-CREATE INDEX entity_name_gist_idx ON entity USING gist(name gist_trgm_ops);
 CREATE INDEX ap_approved_idx ON ap(approved);
 CREATE INDEX ar_approved_idx ON ar(approved);
 CREATE INDEX gl_approved_idx ON gl(approved);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.