| 1 |
3750
|
tao
|
BEGIN;
|
| 2 |
|
|
ALTER TABLE xml_path_index ADD COLUMN nodedatavector TSVECTOR;
|
| 3 |
|
|
UPDATE xml_path_index SET nodedatavector = to_tsvector(nodedata);
|
| 4 |
3751
|
tao
|
CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON xml_path_index FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);
|
| 5 |
3750
|
tao
|
CREATE INDEX xml_path_index_vector ON xml_path_index USING gin(nodedatavector);
|
| 6 |
|
|
COMMIT;
|
| 7 |
3751
|
tao
|
BEGIN;
|
| 8 |
|
|
ALTER TABLE xml_nodes ADD COLUMN nodedatavector TSVECTOR;
|
| 9 |
|
|
UPDATE xml_nodes SET nodedatavector = to_tsvector(nodedata);
|
| 10 |
|
|
CREATE TRIGGER xml_node_tsvectorupdate BEFORE INSERT OR UPDATE ON xml_nodes FOR EACH ROW EXECUTE PROCEDURE tsvector_update_trigger(nodedatavector, 'pg_catalog.english', nodedata);
|
| 11 |
|
|
CREATE INDEX xml_node_vector ON xml_nodes USING gin(nodedatavector);
|
| 12 |
|
|
COMMIT;
|