Re: ERROR: text search configuration "pg_catalog.english" does not exist - Mailing list pgsql-general

From Tom Lane
Subject Re: ERROR: text search configuration "pg_catalog.english" does not exist
Date
Msg-id 6134.1205270700@sss.pgh.pa.us
Whole thread Raw
In response to ERROR: text search configuration "pg_catalog.english" does not exist  (Tim Child <tim@timc3.com>)
Responses Re: ERROR: text search configuration "pg_catalog.english" does not exist
List pgsql-general
Tim Child <tim@timc3.com> writes:
> Hi, I am trying to configure Full Text Search on PostgreSQL 8.3 but I
> seem to be missing pg_catalog.english as I get the follow when I try
> and do this:

That's odd ... what *do* you have in pg_ts_config?  It should look
about like this, in a virgin database:

postgres=# select * from pg_ts_config;
  cfgname   | cfgnamespace | cfgowner | cfgparser
------------+--------------+----------+-----------
 simple     |           11 |       10 |      3722
 danish     |           11 |       10 |      3722
 dutch      |           11 |       10 |      3722
 english    |           11 |       10 |      3722
 finnish    |           11 |       10 |      3722
 french     |           11 |       10 |      3722
 german     |           11 |       10 |      3722
 hungarian  |           11 |       10 |      3722
 italian    |           11 |       10 |      3722
 norwegian  |           11 |       10 |      3722
 portuguese |           11 |       10 |      3722
 romanian   |           11 |       10 |      3722
 russian    |           11 |       10 |      3722
 spanish    |           11 |       10 |      3722
 swedish    |           11 |       10 |      3722
 turkish    |           11 |       10 |      3722
(16 rows)

postgres=#

            regards, tom lane

pgsql-general by date:

Previous
From: sam
Date:
Subject: Trouble with Savepoints in postgres
Next
From: "Rob Wultsch"
Date:
Subject: Re: postgre vs MySQL