This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enigFFD6FC53AD7DDAADD637CEB2
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: quoted-printable
I created a database with locale it_IT@[EMAIL PROTECTED]
and I'm facing a weird=20
problem with tsearch. Let me show it:
tmptest=3D# SELECT * from pg_ts_cfg;
ts_name | prs_name | locale
-----------------+----------+--------------
default_russian | default | ru_RU.KOI8-R
simple | default |
default | default | it_IT@[EMAIL PROTECTED]
(3 righe)
tmptest=3D# SELECT to_tsvector ('ciao mamma');
ERROR: could not find tsearch config by locale
tmptest=3D# UPDATE pg_ts_cfg set locale =3D 'it_IT@[EMAIL PROTECTED]
' where ts_name
=3D=
=20
'default';
UPDATE 1
tmptest=3D# SELECT to_tsvector ('ciao mamma');
to_tsvector
--------------------
'ciao':1 'mamma':2
(1 riga)
tmptest=3D# UPDATE pg_ts_cfg set locale =3D 'it_IT@[EMAIL PROTECTED]
' where ts_name
=3D=
=20
'default';
UPDATE 1
tmptest=3D# SELECT to_tsvector ('ciao mamma');
to_tsvector
--------------------
'ciao':1 'mamma':2
(1 riga)
tmptest=3D# \q
So at first tsearch does not work. If I change it to it_IT@[EMAIL PROTECTED]
it works =
and if I switch back to it_IT@[EMAIL PROTECTED]
it then works even with that locale.
I cannot understand the reason why it happens. By disconnecting from the =
db and connecting again the problem is still there. Do you have any idea =
why it happens?
I don't know if it matters, on the systems I have LANG=3D"it_IT@[EMAIL PROTECTED]
" and=
=20
LANGUAGE=3D"it_IT"
Thanks,
Ottavio
PS: Im running a back****t of postgresql 8.1 on debian sarge.
--=20
Non c'e' piu' forza nella normalita', c'e' solo monotonia.
--------------enigFFD6FC53AD7DDAADD637CEB2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFIB3UrsbKx4ZV8clIRAj4WAJ43PmFS+EcwDbLFE+wrHsBIEvpC4QCfXrd1
9jOVWijIFGb3ODfXYJdb5Nw=
=6lGL
-----END PGP SIGNATURE-----
--------------enigFFD6FC53AD7DDAADD637CEB2--