In my snowball_create.sql I find:
-- No language-specific snowball dictionaries, for lack of shared
library support
This build comes from postgresqlformac.com the "Unified Installer -
8.3.0 (PostgreSQLforMac)"
Now I am considering that it might have been better to compile my own,
but be
There is other things in that directory including dict_snowball.so
ascii_and_mic.so latin2_and_win1250.so utf8_and_big5.so
utf8_and_gbk.so
cyrillic_and_mic.so latin_and_mic.so utf8_and_cyrillic.so
utf8_and_iso8859.so
dict_snowball.sopgxs
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
Tim Child <[EMAIL PROTECTED]> writes:
> There is other things in that directory including dict_snowball.so
Well, that's even stranger. It's real hard to see how the
src/backend/snowball Makefile would have built dict_snowball.so
and not built the correct version of snowball_create.sql.
Anyway,
Tim Child <[EMAIL PROTECTED]> writes:
> There is a file here with the same name:
> /Library/PostgreSQL8/lib/postgresql/plpgsql.so
What else is in that directory? If you don't have dict_snowball.so
it's not gonna work.
> So I could try and run that snowball_create.sql script from src (which
> I
Tim Child <[EMAIL PROTECTED]> 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
Tim Child <[EMAIL PROTECTED]> writes:
> If I do \dF:
> Schema | Name | Description
> ++--
> pg_catalog | simple | simple configuration
> (1 row)
Huh. Seems like initdb forgot to install all the Snowball stemmers.
What do you find in $SHAREDIR/
If I do \dF:
Schema | Name | Description
++--
pg_catalog | simple | simple configuration
(1 row)
\dFd:
Schema | Name |Description
+
+-
Tim Child <[EMAIL PROTECTED]> 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 da
Tim Child wrote:
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:
tsvector_update_trigger(body_tsv, 'pg_catalog.english', notes);
Error:
ERROR: text search configuration "pg_catalog.eng
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:
ALTER TABLE useraccounts_contact ADD COLUMN notes_tsv tsvector;
CREATE TRIGGER tsvectorupdate BEFORE INSERT OR UPDATE ON
useraccounts_conta
11 matches
Mail list logo
