| Index: branches/REL1_17/phase3/maintenance/postgres/tables.sql |
| — | — | @@ -495,7 +495,7 @@ |
| 496 | 496 | CREATE INDEX job_cmd_namespace_title ON job (job_cmd, job_namespace, job_title); |
| 497 | 497 | |
| 498 | 498 | -- Tsearch2 2 stuff. Will fail if we don't have proper access to the tsearch2 tables |
| | 499 | +-- Version 8.3 or higher only. Previous versions would need another parmeter for to_tsvector. |
| 499 | 500 | -- Make sure you also change patch-tsearch2funcs.sql if the funcs below change. |
| 500 | 501 | |
| 501 | 502 | ALTER TABLE page ADD titlevector tsvector; |
| — | — | @@ -503,9 +503,9 @@ |
| 504 | 504 | $mw$ |
| 505 | 505 | BEGIN |
| 506 | 506 | IF TG_OP = 'INSERT' THEN |
| 507 | | - NEW.titlevector = to_tsvector('default',REPLACE(NEW.page_title,'/',' ')); |
| | 507 | + NEW.titlevector = to_tsvector(REPLACE(NEW.page_title,'/',' ')); |
| 508 | 508 | ELSIF NEW.page_title != OLD.page_title THEN |
| 509 | | - NEW.titlevector := to_tsvector('default',REPLACE(NEW.page_title,'/',' ')); |
| | 509 | + NEW.titlevector := to_tsvector(REPLACE(NEW.page_title,'/',' ')); |
| 510 | 510 | END IF; |
| 511 | 511 | RETURN NEW; |
| 512 | 512 | END; |
| — | — | @@ -520,9 +520,9 @@ |
| 521 | 521 | $mw$ |
| 522 | 522 | BEGIN |
| 523 | 523 | IF TG_OP = 'INSERT' THEN |
| 524 | | - NEW.textvector = to_tsvector('default',NEW.old_text); |
| | 524 | + NEW.textvector = to_tsvector(NEW.old_text); |
| 525 | 525 | ELSIF NEW.old_text != OLD.old_text THEN |
| 526 | | - NEW.textvector := to_tsvector('default',NEW.old_text); |
| | 526 | + NEW.textvector := to_tsvector(NEW.old_text); |
| 527 | 527 | END IF; |
| 528 | 528 | RETURN NEW; |
| 529 | 529 | END; |
| Index: branches/REL1_17/phase3/RELEASE-NOTES |
| — | — | @@ -87,6 +87,8 @@ |
| 88 | 88 | any necessary database tables. |
| 89 | 89 | * (bug 28983) Fixed automated installation of extensions that overwrite $path. |
| 90 | 90 | * Fixed error caused by missing magic words. |
| | 91 | +* Fixed breakage of article editing in PostgreSQL due to text search |
| | 92 | + configuration errors. |
| 91 | 93 | |
| 92 | 94 | === Configuration changes in 1.17 === |
| 93 | 95 | |