Fisheye: Tag 1.5 refers to a dead (removed) revision in file `openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-create.sql'. Fisheye: No comparison available. Pass `N' to diff? Index: openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-create.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-create.sql 28 Jun 2004 14:30:40 -0000 1.1 @@ -0,0 +1,21 @@ +-- +-- tsearch2 based FTSEngineDriver for Search package +-- +-- @author Dave Bauer (dave@thedesignexperience.org) +-- @creation-date 2004-06-05 +-- @arch-tag: 25662a8a-e960-4888-bd9f-3e7a8fff5637 +-- @cvs-id $Id: tsearch2-driver-create.sql,v 1.1 2004/06/28 14:30:40 daveb Exp $ +-- + +-- FIXME need to load tsearch2.sql from postgresql/share/contrib +-- (on debian /usr/share/postgresql/contrib) +create table txt ( + object_id integer + constraint txt_object_id_fk + references acs_objects, + fti tsvector +); + +create index fti_idx on txt using gist(fti); +create index object_id_idx on txt (object_id); + Index: openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-drop.sql,v diff -u --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-driver-drop.sql 28 Jun 2004 14:30:40 -0000 1.1 @@ -0,0 +1,10 @@ +-- +-- +-- +-- @author Dave Bauer (dave@thedesignexperience.org) +-- @creation-date 2004-06-05 +-- @arch-tag: da4f668f-eba3-40a1-8efb-23c347e312c9 +-- @cvs-id $Id: tsearch2-driver-drop.sql,v 1.1 2004/06/28 14:30:40 daveb Exp $ +-- + +drop table txt; Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-drop.sql'. Fisheye: No comparison available. Pass `N' to diff?