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

There is a file here with the same name:

/Library/PostgreSQL8/lib/postgresql/plpgsql.so

So I could try and run that snowball_create.sql script from src (which
I have downloaded) and try and get the required functionality? That
would be the easiest for now.

On the production system I will compile my own PostgreSQL but for now
I wanted a minimum of fuss setup ;-)

Thanks again for all the help.

Tim.

On 12 Mar 2008, at 17:03, Tom Lane wrote:

> Tim Child <tim(at)timc3(dot)com> writes:
>> In my snowball_create.sql I find:
>> -- No language-specific snowball dictionaries, for lack of shared
>> library support
>
> Really!?
>
>> This build comes from postgresqlformac.com the "Unified Installer -
>> 8.3.0 (PostgreSQLforMac)"
>
> Hm, do they have plpgsql or any of the other PLs? It's hard to credit
> that anyone would put out a build without shared library support.
> There's too much functionality that goes missing.
>
>> Now I am considering that it might have been better to compile my
>> own,
>> but before I do this is there anyway to get the libraries /
>> dictionaries installed?
>
> What you need is a non-lobotomized build. You should be able to fix
> the
> problem without re-initdb, if you need to, by running the real
> snowball_create.sql script against each of your databases.
>
> regards, tom lane