Merge branch 'master' of git.evergreen-ils.org:Evergreen into authority-control-sets
authorMike Rylander <mrylander@gmail.com>
Tue, 17 May 2011 14:18:43 +0000 (10:18 -0400)
committerMike Rylander <mrylander@gmail.com>
Tue, 17 May 2011 14:18:43 +0000 (10:18 -0400)
1  2 
Open-ILS/src/sql/Pg/011.schema.authority.sql

@@@ -127,9 -85,10 +128,10 @@@ CREATE TABLE authority.full_rec 
  CREATE INDEX authority_full_rec_record_idx ON authority.full_rec (record);
  CREATE INDEX authority_full_rec_tag_subfield_idx ON authority.full_rec (tag, subfield);
  CREATE INDEX authority_full_rec_tag_part_idx ON authority.full_rec (SUBSTRING(tag FROM 2));
+ CREATE INDEX authority_full_rec_subfield_a_idx ON authority.full_rec (value) WHERE subfield = 'a';
  CREATE TRIGGER authority_full_rec_fti_trigger
 -      BEFORE UPDATE OR INSERT ON authority.full_rec
 -      FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
 +    BEFORE UPDATE OR INSERT ON authority.full_rec
 +    FOR EACH ROW EXECUTE PROCEDURE tsearch2(index_vector, value);
  
  CREATE INDEX authority_full_rec_index_vector_idx ON authority.full_rec USING GIST (index_vector);
  /* Enable LIKE to use an index for database clusters with locales other than C or POSIX */