Bug 285443: Schema::Pg should remove FULLTEXT attribute from indexes

Patch By Ed Sabol <edwardjsabol@iname.com> r=mkanat, a=justdave

1 files changed, 16 insertions, 0 deletions

diff --git a/Bugzilla/DB/Schema/Pg.pm b/Bugzilla/DB/Schema/Pg.pm
index 23806aed1..c5b229278 100644
--- a/Bugzilla/DB/Schema/Pg.pm
+++ b/Bugzilla/DB/Schema/Pg.pm
@@ -39,6 +39,22 @@ sub _initialize {
 
     $self = $self->SUPER::_initialize;
 
+    # Remove FULLTEXT index types from the schemas.
+    foreach my $table (keys %{ $self->{schema} }) {
+        if ($self->{schema}{$table}{INDEXES}) {
+            foreach my $index (@{ $self->{schema}{$table}{INDEXES} }) {
+                if (ref($index) eq 'HASH') {
+                    delete($index->{TYPE}) if ($index->{TYPE} eq 'FULLTEXT');
+                }
+            }
+            foreach my $index (@{ $self->{abstract_schema}{$table}{INDEXES} }) {
+                if (ref($index) eq 'HASH') {
+                    delete($index->{TYPE}) if ($index->{TYPE} eq 'FULLTEXT');
+                }
+            }
+        }
+    }
+
     $self->{db_specific} = {
 
         BOOLEAN =>      'smallint',