Project

General

Profile

Revision 3353

Added by Jing Tao about 14 years ago

Change path data type to text in table xml_index.

View differences:

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