Thread: 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 <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/>
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.