converting ts2vektor to postgres 9.1
От | robert rottermann |
---|---|
Тема | converting ts2vektor to postgres 9.1 |
Дата | |
Msg-id | 4EB2B80B.5000005@redcor.ch обсуждение исходный текст |
Список | pgsql-general |
hi there, I habe to upgrade a db from 8.4 to 91 that is using tsvector (that was converted from an older version before). now I am looking for pointer on how to proceed. for insance in the dump from the old db I find declarations like added at the end (and lots more): I think these are these are triggers, that add so keywords to an full text intex. Documents are then retrieved with somethin like ... FROM mitarbeiter, pg_class WHERE ( idxfti_mitarbeiter @@ to_tsquery('default', 'some keyword' ) ) AND pg_class.oid = mitarbeiter.tableoid ... how would I convert that to the "integrated" full text search. thanks for your time Robert -- -- Name: tsearch2(); Type: FUNCTION; Schema: public; Owner: fiu -- CREATE FUNCTION tsearch2() RETURNS "trigger" AS '$libdir/tsearch2', 'tsearch2' LANGUAGE c; ALTER FUNCTION public.tsearch2() OWNER TO fiu; -- -- Name: tsq_mcontained(tsquery, tsquery); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION tsq_mcontained(tsquery, tsquery) RETURNS boolean AS '$libdir/tsearch2', 'tsq_mcontained' LANGUAGE c IMMUTABLE STRICT; ALTER FUNCTION public.tsq_mcontained(tsquery, tsquery) OWNER TO postgres; -- -- Name: tsq_mcontains(tsquery, tsquery); Type: FUNCTION; Schema: public; Owner: postgres -- CREATE FUNCTION tsq_mcontains(tsquery, tsquery) RETURNS boolean AS '$libdir/tsearch2', 'tsq_mcontains' LANGUAGE c IMMUTABLE STRICT;
В списке pgsql-general по дате отправления: