Обсуждение: tsearch2 upgrade problem and mediawiki
After upgrading from Postgres 8.1 to 8.2 (via pg_dumpall) I had problems with mediawiki (v1.9.2) that utilized tsearch2. I thought I had fixed the problem by removing tsearch2 in my v8.1 databases, pg_dumpall-ing and reloading to v8.2, and re-installing tsearch2 from scratch. When updating a page in mediawiki, I get an error. This is what I am seeing in my pg_log: STATEMENT: SELECT nextval('rev_rev_id_val') ERROR: record "new" has no field "textvector" CONTEXT: PL/pgSQL function "ts2_page_text" line 3 at assignment STATEMENT: INSERT /* Revision::insertOn */ INTO pagecontent (old_id,old_text,old_flags) VALUES ('2128','{| class="wikitable [snip] The table "pagecontent" has a trigger: wikidb=> \d pagecontent Table "mediawiki.pagecontent" Column | Type | Modifiers -----------+---------+------------------------------------------------------- old_id | integer | not null default nextval('text_old_id_val'::regclass) old_text | text | old_flags | text | Indexes: "pagecontent_pkey" PRIMARY KEY, btree (old_id) Triggers: ts2_page_text BEFORE INSERT OR UPDATE ON pagecontent FOR EACH ROW EXECUTE PROCEDURE ts2_page_text() with this code: BEGIN IF TG_OP = 'INSERT' THEN NEW.textvector = to_tsvector('default',NEW.old_text); ELSIF NEW.old_text != OLD.old_text THEN NEW.textvector := to_tsvector('default',NEW.old_text); END IF; RETURN NEW; END; This looks like a problem with tsearch2 to me... can anyone give me a pointer on where to go from here to debug this? Thanks! -Jon -- -**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*--- Jon Lapham <lapham@jandr.org> Rio de Janeiro, Brasil Personal: http://www.jandr.org/ ***-*--*----*-------*------------*--------------------*---------------
Jon Lapham wrote: > After upgrading from Postgres 8.1 to 8.2 (via pg_dumpall) I had problems > with mediawiki (v1.9.2) that utilized tsearch2. I thought I had fixed > the problem by removing tsearch2 in my v8.1 databases, pg_dumpall-ing > and reloading to v8.2, and re-installing tsearch2 from scratch. > > When updating a page in mediawiki, I get an error. This is what I am > seeing in my pg_log: > > STATEMENT: SELECT nextval('rev_rev_id_val') > ERROR: record "new" has no field "textvector" > BEGIN > IF TG_OP = 'INSERT' THEN > NEW.textvector = to_tsvector('default',NEW.old_text); > ELSIF NEW.old_text != OLD.old_text THEN > NEW.textvector := to_tsvector('default',NEW.old_text); > END IF; > RETURN NEW; > END; > > This looks like a problem with tsearch2 to me... can anyone give me a > pointer on where to go from here to debug this? Thanks! Well, that's a trigger that's updating a column called "textvector" of type tsvector (a tsearch2 type). It's not a tsearch2 trigger function though, so presumably it comes with mediawiki. Try just adding the column, I'm guessing it was dropped while you were taking out the old tsearch2 installation. ALTER TABLE pagecontent ADD COLUMN textvector tsvector; Incidentally, I tend to install tsearch2 in its own schema now, makes it simpler to check what's installed. It does mean you need to do alter your search_path though. Oh, and 8.3 will have tsearch as a built-in. -- Richard Huxton Archonet Ltd
Richard Huxton wrote: > Try just adding the column, I'm guessing it was dropped while you were > taking out the old tsearch2 installation. > ALTER TABLE pagecontent ADD COLUMN textvector tsvector; Thanks, that fixed the problem. -- -**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*--- Jon Lapham <lapham@jandr.org> Rio de Janeiro, Brasil Personal: http://www.jandr.org/ ***-*--*----*-------*------------*--------------------*---------------