> > Users of contrib/tsearch needs after upgrading of module (compiling, installing)

> > to perform sql command:
> >  update pg_amop set amopreqcheck = true where amopclaid =
> >       (select oid from pg_opclass where opcname = 'gist_txtidx_ops');
>
> Oleg, sorry, I don't understand where this should appear.  In the README
> file, and if so, where?  Is this something only for people upgrading
> from 7.2?

Sorry Bruce, I was unclear. I have attached patch to Readme.tsearch
Also, It'd be worth to mention in Changes to point users of tsearch
about importang upgrade notices.

Oleg Bartunov

3 files changed, 16 insertions, 5 deletions

diff --git a/HISTORY b/HISTORY
index 70bf0062e74..0cafbab1713 100644
--- a/HISTORY
+++ b/HISTORY
@@ -20,7 +20,6 @@ Changes
  Fix pgaccess kanji-coversion key binding (Tatsuo)
  Optimizer improvements (Tom)
  cash I/O improvements (Tom)
- contrib/btree_gist improvements (Teodor Sigaev)
  New Russian FAQ
  Compile fix for missing AuthBlockSig (Heiko)
  Additional time zones and time zone fixes (Thomas)
@@ -29,7 +28,9 @@ Changes
  Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo)
  Fix bug in extract/date_part for milliseconds/microseconds (Tatsuo)
  Improve handling of multiple UNIONs with different lengths (Tom)
- contrib/tsearch dictionary improvements (Thomas T. Thai, Teodor Sigaev)
+ contrib/btree_gist improvements (Teodor Sigaev)
+ contrib/tsearch dictionary improvements, see README.tsearch for
+   an additional installation step (Thomas T. Thai, Teodor Sigaev)
  Fix for array subscripts handling (Tom)
      
 
diff --git a/contrib/tsearch/README.tsearch b/contrib/tsearch/README.tsearch
index c63ae91edd0..36ab97face4 100644
--- a/contrib/tsearch/README.tsearch
+++ b/contrib/tsearch/README.tsearch
@@ -4,6 +4,15 @@ a searchable data type (textual) with indexed access.
 All work was done by Teodor Sigaev (teodor@stack.net) and Oleg Bartunov
 (oleg@sai.msu.su).
 
+CHANGES:
+  
+  To upgrade from 7.2 to 7.2.1 one needs to perform following sql
+  (after compiling and installing contrib/tsearch):
+
+  update pg_amop set amopreqcheck = true where amopclaid =
+     (select oid from pg_opclass where opcname = 'gist_txtidx_ops');
+
+
 IMPORTANT NOTICE:
 
 This is a first step of our work on integration of OpenFTS
diff --git a/doc/src/sgml/release.sgml b/doc/src/sgml/release.sgml
index 3459644f94d..4395700a4b4 100644
--- a/doc/src/sgml/release.sgml
+++ b/doc/src/sgml/release.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.115.2.2 2002/03/19 00:12:41 momjian Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/release.sgml,v 1.115.2.3 2002/03/19 14:16:32 momjian Exp $
 -->
 
 <appendix id="release">
@@ -36,7 +36,6 @@ Ensure that sequence counters do not go backwards after a crash (Tom)
 Fix pgaccess kanji-coversion key binding (Tatsuo)
 Optimizer improvements (Tom)
 cash I/O improvements (Tom)
-contrib/btree_gist improvements (Teodor Sigaev)
 New Russian FAQ
 Compile fix for missing AuthBlockSig (Heiko)
 Additional time zones and time zone fixes (Thomas)
@@ -45,7 +44,9 @@ Return proper OID on command completion even with ON INSERT rules (Tom)
 Allow COPY FROM to use 8-bit DELIMITERS (Tatsuo)
 Fix bug in extract/date_part for milliseconds/microseconds (Tatsuo)
 Improve handling of multiple UNIONs with different lengths (Tom)
-contrib/tsearch dictionary improvements (Thomas T. Thai, Teodor Sigaev)
+contrib/btree_gist improvements (Teodor Sigaev)
+contrib/tsearch dictionary improvements, see README.tsearch for
+  an additional installation step (Thomas T. Thai, Teodor Sigaev)
 Fix for array subscripts handling (Tom)
      </programlisting>
     </para>