Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux