Page MenuHomePhabricator

tsearch changes in PostgreSQL 8.3
Closed, ResolvedPublic

Description

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

Details

Reference
bz12732

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to High.Nov 21 2014, 10:01 PM
bzimport set Reference to bz12732.
bzimport added a subscriber: Unknown Object (MLST).

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))

#12 {main}

dothack wrote:

*** Bug 12821 has been marked as a duplicate of this bug. ***

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.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.