Index: openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/tsearch2-driver/sql/postgresql/Attic/tsearch2-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-create.sql 6 Jun 2004 01:49:41 -0000 1.2 +++ openacs-4/packages/tsearch2-driver/sql/postgresql/tsearch2-create.sql 6 Jun 2004 20:03:33 -0000 1.3 @@ -17,4 +17,10 @@ ); create index fti_idx on txt using gist(fti); +create index object_id_idx on txt (object_id); +-- set to default configuration +-- user may set up additional dictionaries and change the config +-- there will be a parameter to select the config name + +select set_curcrg('default');