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