Last modified: 2012-08-04 20:48:44 UTC
In PostgreSQL 8.3 all of the tsearch functionality is now integrated. http://www.postgresql.org/docs/8.3/static/textsearch.html Thankfully since this only affects Postgres, changes should (AFAIK) be minimal.
Oh I guess I should have mentioned this completely breaks a new install. Not sure about existing installations, everything but searches should work. Don't really know where this should go on the priority or severity list as Postgres 8.3 is at RC2.
I stand corrected, this affects editing pages as well. === A database error has occurred Query: INSERT INTO page (page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len) VALUES ('3','0','Main_Page','0','','0','1','0.830391437959','2008-01-26 03:15:23 GMT','0','0') Function: Article::insertOn Error: 1 ERROR: text search configuration "default" does not exist CONTEXT: PL/pgSQL function "ts2_page_title" line 3 at assignment Backtrace: #0 /home/wiki/includes/Database.php(799): DatabasePostgres->reportQueryError('ERROR: text se...', 1, 'INSERT INTO pag...', 'Article::insert...', 0) #1 /home/wiki/includes/DatabasePostgres.php(767): Database->query('INSERT INTO pag...', 'Article::insert...', 0) #2 /home/wiki/includes/Article.php(1011): DatabasePostgres->insert('page', Array, 'Article::insert...') #3 /home/wiki/includes/Article.php(1425): Article->insertOn(Object(DatabasePostgres)) #4 /home/wiki/includes/Article.php(1202): Article->doEdit('asdfasdf', 'asdf', 97) #5 /home/wiki/includes/EditPage.php(820): Article->insertNewArticle('asdfasdf', 'asdf', false, false, false, false, false) #6 /home/wiki/includes/EditPage.php(2180): EditPage->internalAttemptSave(false, false) #7 /home/wiki/includes/EditPage.php(463): EditPage->attemptSave() #8 /home/wiki/includes/EditPage.php(323): EditPage->edit() #9 /home/wiki/includes/Wiki.php(444): EditPage->submit() #10 /home/wiki/includes/Wiki.php(48): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest)) #11 /home/wiki/index.php(89): MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User), Object(WebRequest)) #12 {main} ===
*** Bug 12821 has been marked as a duplicate of this bug. ***
Final version of postgresql 8.3 is planned to be in a month as maximum and servers depending only on postgresql can't use mediawiki. I need to be in version 8.3 for other software I have so downgrading is something that can't be done.
This is fixed for new installs as of r30795, but no provision for upgrading from pre 8.3 installations yet.
