Re: access method "gin" does not exist

Run initdb after patching

Kevin Murphy wrote:
> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/