unable to install tsearch2 on PostgreSQL 8.3.7 successfully

From: l0rins <ahmedadel_109(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: unable to install tsearch2 on PostgreSQL 8.3.7 successfully
Date: 2009-04-10 15:01:04
Message-ID: 22989298.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jasen Betts 2009-04-10 15:09:42 Re: How would I get rid of trailing blank line?
Previous Message Michael Renner 2009-04-10 14:59:51 Re: Documentation Update: WAL & Checkpoints