Author: overlordq
Description:
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.
Version: 1.12.x
Severity: major
| Status | Subtype | Assigned | Task | |
|---|---|---|---|---|
| · · · | ||||
| Invalid | None | T2384 [REPLACED BY TAG] PostgreSQL/pgsql support (tracking) | ||
| Resolved | None | T14732 tsearch changes in PostgreSQL 8.3 | ||
| · · · |
overlordq wrote:
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.
overlordq wrote:
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))
dothack wrote:
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.