Index: openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql,v
diff -u -r1.13.2.1 -r1.13.2.2
--- openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 15 Mar 2019 08:54:10 -0000 1.13.2.1
+++ openacs-4/packages/tsearch2-driver/tcl/tsearch2-driver-procs-postgresql.xql 9 Mar 2020 12:58:40 -0000 1.13.2.2
@@ -4,10 +4,11 @@
postgresql8.3
insert into txt (object_id,fti)
- values (:object_id,
- setweight(to_tsvector(coalesce(:title,'')),'A')
- ||setweight(to_tsvector(coalesce(:keywords,'')),'B')
- ||to_tsvector(coalesce(:txt,'')))
+ select object_id,
+ setweight(to_tsvector(coalesce(:title,'')),'A')
+ ||setweight(to_tsvector(coalesce(:keywords,'')),'B')
+ ||to_tsvector(coalesce(:txt,'')))
+ from acs_objects where object_id = :object_id