Re: unable to install tsearch2 on PostgreSQL 8.3.7 successfully

l0rins <ahmedadel_109@yahoo.com> writes:
> In version 8.1, tsearch2.sql contained SQL statements to create 4 pg_ts_*
> tables: pg_ts_cfg, pg_ts_dict, ... and populate them with data. These
> statements are missing in tsearch2.sql 8.3.7 version. So, I'm getting:
> ERROR:  relation "pg_ts_*" does not exist when trying to run tsearch
> statements on version 8.3.2.

You need to read the documentation --- 8.3's text search facility
is quite a lot different from previous releases, and contrib/tsearch2
is now just a compatibility layer that does not fully hide the
differences.
http://www.postgresql.org/docs/8.3/static/textsearch-migration.html
        regards, tom lane

Thanks for your reply!

Actually, I read this Postgresql documentation before
(http://www.postgresql.org/docs/8.3/static/textsearch-migration.html), but
it's still very unclear to me how to install tsearch2 module on Postgres
v8.3.7 from scratch. In fact, I'm relying on tsearch2 docs for installation
instructions here:

http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/tsearch-V2-intro.html

but it apparently doesn't work with Postgres v8.3.7

I would be grateful if you could provide more information on that.

Thanks,
Adel
-- 
View this message in context:
http://www.nabble.com/unable-to-install-tsearch2-on-PostgreSQL-8.3.7-successfully-tp22989298p22994030.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.