Thread: unable to install tsearch2 on PostgreSQL 8.3.7 successfully

unable to install tsearch2 on PostgreSQL 8.3.7 successfully

From
l0rins
Date:
Hello, I'm trying to install tsearch2 on PostgreSQL 8.3.7 but I'm struggling to get it run. I installed it
<b>successfullyon PostgreSQL 8.1</b> but can't get it working on 8.3.7 using the same steps. The steps I'm using are:
1.yum install postgresql-contrib 2. psql mydb < tsearch2.sql In version 8.1, tsearch2.sql contained SQL statements
tocreate 4 pg_ts_* tables: pg_ts_cfg, pg_ts_dict, ... and populate them with data. These statements <b>are missing in
tsearch2.sql8.3.7 version</b>. So, I'm getting: ERROR: relation "<i>pg_ts_*</i>" does not exist when trying to run
tsearchstatements on version 8.3.2. I'm attaching PostgreSQL 8.3.7 tsearch2.sql for reference. Am I missing something?
Thanksin advance. l0rins<a href="http://www.nabble.com/file/p22989298/tsearch2.sql" target="_top">tsearch2.sql</a><br
/><hralign="left" width="300" /> View this message in context: <a
href="http://www.nabble.com/unable-to-install-tsearch2-on-PostgreSQL-8.3.7-successfully-tp22989298p22989298.html">unable
toinstall tsearch2 on PostgreSQL 8.3.7 successfully</a><br /> Sent from the <a
href="http://www.nabble.com/PostgreSQL---hackers-f780.html">PostgreSQL- hackers mailing list archive</a> at
Nabble.com.<br/> 

Re: unable to install tsearch2 on PostgreSQL 8.3.7 successfully

From
Tom Lane
Date:
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


Re: unable to install tsearch2 on PostgreSQL 8.3.7 successfully

From
l0rins
Date:


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.