From: | Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> |
---|---|
To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | access method "gin" does not exist |
Date: | 2006-07-20 16:25:39 |
Message-ID: | 44BFAE83.8020104@genome.chop.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to test the 8.1 backport of the 8.2 GIN index and tsearch2
functionality.
The patch is applied successfully (to 8.1.4, on OS X 10.4.7 w/ xcode
2.3), the build and install goes well, stop & start of postmaster is
done, but initializing tsearch2 fails:
psql -U postgres minitest <
/usr/local/src/postgresql-8.1.4/contrib/tsearch2/tsearch2.sql
...
ERROR: access method "gin" does not exist
This error occurs at the following statement:
CREATE OPERATOR CLASS gin_tsvector_ops
DEFAULT FOR TYPE tsvector USING gin
AS
OPERATOR 1 @@ (tsvector, tsquery),
OPERATOR 2 @@@ (tsvector, tsquery) RECHECK,
FUNCTION 1 bttextcmp(text, text),
FUNCTION 2 gin_extract_tsvector(tsvector,internal),
FUNCTION 3
gin_extract_tsquery(tsquery,internal,internal),
FUNCTION 4
gin_ts_consistent(internal,internal,tsquery),
STORAGE text;
Sanity checks:
1) In PSQL:
select amname from pg_am where amname like '%gin%';
amname
--------
(0 rows)
Hmm. Should I expect this query to return something?
show gin_fuzzy_search_limit;
gin_fuzzy_search_limit
------------------------
0
(1 row)
Thanks for any tips,
Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Dan Strömberg | 2006-07-20 18:21:15 | Column info without executing query |
Previous Message | Eric Faulhaber | 2006-07-20 16:07:54 | Re: UTF8 conversion differences from v8.1.3 to v8.1.4 |