unable to install tsearch2 on PostgreSQL 8.3.7 successfully
Hello,
I'm trying to install tsearch2 on PostgreSQL 8.3.7 but I'm struggling to get
it run. I installed it successfully on PostgreSQL 8.1 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 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.
I'm attaching PostgreSQL 8.3.7 tsearch2.sql for reference.
Am I missing something?
Thanks in advance.
l0rins http://www.nabble.com/file/p22989298/tsearch2.sql tsearch2.sql
--
View this message in context: http://www.nabble.com/unable-to-install-tsearch2-on-PostgreSQL-8.3.7-successfully-tp22989298p22989298.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.
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
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.