rdbms: Remove support for PostgreSQL < 9.2, and improve INSERT IGNORE for 9.5

[lhc/web/wiklou.git] / maintenance / postgres / archives / patch-ts2pagetitle.sql

diff --git a/maintenance/postgres/archives/patch-ts2pagetitle.sql b/maintenance/postgres/archives/patch-ts2pagetitle.sql
index 4ac985e..a770c91 100644 (file)
--- a/maintenance/postgres/archives/patch-ts2pagetitle.sql
+++ b/maintenance/postgres/archives/patch-ts2pagetitle.sql
@@ -4,9 +4,9 @@ LANGUAGE plpgsql AS
 $mw$
 BEGIN
 IF TG_OP = 'INSERT' THEN
-  NEW.titlevector = to_tsvector('default',REPLACE(NEW.page_title,'/',' '));
+  NEW.titlevector = to_tsvector(REPLACE(NEW.page_title,'/',' '));
 ELSIF NEW.page_title != OLD.page_title THEN
-  NEW.titlevector := to_tsvector('default',REPLACE(NEW.page_title,'/',' '));
+  NEW.titlevector := to_tsvector(REPLACE(NEW.page_title,'/',' '));
 END IF;
 RETURN NEW;
 END;