aboutsummaryrefslogtreecommitdiffstats
path: root/maintenance/postgres/archives/patch-textsearch_bug66650.sql
blob: c3704af0b3cb61eddfd3e423f271f5019dec19ca (plain) (blame)
1
2
3
4
5
UPDATE /*_*/text 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');