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@xxxxxxxxx> 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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
