From: | robert rottermann <robert(at)redcor(dot)ch> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | converting ts2vektor to postgres 9.1 |
Date: | 2011-11-03 15:49:31 |
Message-ID: | 4EB2B80B.5000005@redcor.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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;
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2011-11-03 15:52:34 | Re: 9.1 replication on different arch |
Previous Message | Tom Lane | 2011-11-03 15:37:54 | Re: Strange problem with create table as select * from table; |