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

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@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
> ------------+--------------+----------+-----------