Обсуждение: BUG #3539: tsearch2 broken on Intel Macs running Leopard

The following bug has been logged online:

Bug reference:      3539
Logged by:          Erik R.
Email address:      erik@mage.net
PostgreSQL version: 8.2.4
Operating system:   Mac OS X 10.5 (9A499)
Description:        tsearch2 broken on Intel Macs running Leopard
Details:

Any tsearch query results in the following error message:

mydb=# select * from product_search('test');
ERROR:  could not find tsearch config by locale
CONTEXT:  SQL function "product_search" statement 1

Same thing on 8.2.3.  The same database works fine on a PPC Mac running the
same Leopard build as well as various flavors of Linux.

I wish I had more information to give you.

Cheers,
Erik

"Erik R." <erik@mage.net> writes:
> Any tsearch query results in the following error message:
> mydb=# select * from product_search('test');
> ERROR:  could not find tsearch config by locale

What does "locale" report on your machine?  AFAICS this error message
just means that "setlocale(LC_CTYPE, NULL)" returned a string that did
not match any entry in pg_ts_cfg.

            regards, tom lane