summaryrefslogtreecommitdiff
path: root/maintenance/postgres/archives/patch-textsearch_bug66650.sql
blob: e4f5681c452ff1db37ebdd6d078eee6093d0b1ea (plain)
1
2
3
4
5
UPDATE /*_*/pagecontent SET textvector=to_tsvector(old_text)
WHERE textvector IS NULL AND old_id IN 
(SELECT  max(rev_text_id) FROM revision GROUP BY rev_page);

INSERT INTO /*_*/updatelog(ul_key) VALUES ('patch-textsearch_bug66650.sql');