From a15997715389c196de4f98c1a93c5d71206b2ccd Mon Sep 17 00:00:00 2001 From: Greg Sabino Mullane Date: Wed, 19 Jan 2011 16:14:37 +0000 Subject: [PATCH] Use text_pattern_ops for page_title, as some code uses 'anchor%' matching. --- maintenance/postgres/tables.sql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index 0b72b36796..c302361863 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -63,12 +63,12 @@ CREATE TABLE page ( page_len INTEGER NOT NULL ); CREATE UNIQUE INDEX page_unique_name ON page (page_namespace, page_title); -CREATE INDEX page_main_title ON page (page_title) WHERE page_namespace = 0; -CREATE INDEX page_talk_title ON page (page_title) WHERE page_namespace = 1; -CREATE INDEX page_user_title ON page (page_title) WHERE page_namespace = 2; -CREATE INDEX page_utalk_title ON page (page_title) WHERE page_namespace = 3; -CREATE INDEX page_project_title ON page (page_title) WHERE page_namespace = 4; -CREATE INDEX page_mediawiki_title ON page (page_title) WHERE page_namespace = 8; +CREATE INDEX page_main_title ON page (page_title text_pattern_ops) WHERE page_namespace = 0; +CREATE INDEX page_talk_title ON page (page_title text_pattern_ops) WHERE page_namespace = 1; +CREATE INDEX page_user_title ON page (page_title text_pattern_ops) WHERE page_namespace = 2; +CREATE INDEX page_utalk_title ON page (page_title text_pattern_ops) WHERE page_namespace = 3; +CREATE INDEX page_project_title ON page (page_title text_pattern_ops) WHERE page_namespace = 4; +CREATE INDEX page_mediawiki_title ON page (page_title text_pattern_ops) WHERE page_namespace = 8; CREATE INDEX page_random_idx ON page (page_random); CREATE INDEX page_len_idx ON page (page_len); -- 2.20.1