Project

General

Profile

« Previous | Next » 

Revision 7053

Added by ben leinfelder over 12 years ago

increase amount of text the 'xml_path_index.path' column can accommodate. I was seeing errors like this during indexing:
knb 20120312-11:42:05: [ERROR]: DocumentImpl.buildIndex - SQL Exception while indexing document knb-lter-and.3147 : ERROR: value too long for type character varying(1000) [edu.ucsb.nceas.metacat.DocumentImpl]

View differences:

upgrade-db-to-2.0.0-postgres.sql
163 163 
 */
164 164 
ALTER TABLE xml_access DROP COLUMN docid;
165 165 

  		




  
  166
  
    

  		




  
  167
  
    
/**


  		




  
  168
  
    
 * expand xml_path_index 'path' column to hold larger strings 


  		




  
  169
  
    
 */


  		




  
  170
  
    
ALTER TABLE xml_path_index ALTER COLUMN path TYPE text;


  		




  
  171
  
    

  		




  166
  172
  
    
/*


  		




  167
  173
  
    
 * update the database version


  		




  168
  174
  
    
 */


  		












Also available in:  Unified diff