Re: ERROR: text search configuration "pg_catalog.english" does not exist

If I do \dF:

Schema | Name | Description
------------+--------+----------------------
pg_catalog | simple | simple configuration
(1 row)

\dFd:

Schema | Name | Description
------------+--------
+-----------------------------------------------------------
pg_catalog | simple | simple dictionary: just lower case and check
for stopword

And for select * from pg_ts_config the only row shows:

simple |11 | 10 | 3722

Is there away of getting the extra catalogues in?

Thanks,

Tim.

On 11 Mar 2008, at 22:25, Tom Lane wrote:

> Tim Child <tim(at)timc3(dot)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
> ------------+--------------+----------+-----------