Project

General

Profile

« Previous | Next » 

Revision 3353

Added by Jing Tao over 17 years ago

Change path data type to text in table xml_index.

View differences:

src/upgrade-db-to-1.7.1-postgres.sql
24 24 
UPDATE xml_path_index SET column_new = nodedata;
25 25 
ALTER TABLE xml_path_index DROP COLUMN nodedata;
26 26 
ALTER TABLE xml_path_index RENAME column_new TO nodedata;
27 
DROP INDEX xml_path_index_idx2;
28 27 
CREATE INDEX xml_path_index_idx2 ON xml_path_index (nodedata);
29 28 
COMMIT;
30 29 

  		




  
  30
  
    
BEGIN;


  		




  
  31
  
    
ALTER TABLE xml_index ADD COLUMN column_new TEXT;


  		




  
  32
  
    
UPDATE xml_index SET column_new = path;


  		




  
  33
  
    
ALTER TABLE xml_index DROP COLUMN path;


  		




  
  34
  
    
ALTER TABLE xml_index RENAME column_new TO path;


  		




  
  35
  
    
CREATE INDEX xml_index_idx1 ON xml_index (path);


  		




  
  36
  
    
COMMIT;


  		




  
  37
  
    

  		




  
  38
  
    

  		




  31
  39
  
    
CREATE INDEX xml_index_idx2 ON xml_index (docid);


  		












Also available in:  Unified diff