Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > problem with ts...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 15312 of 17602
Post > Topic >>

problem with tsearch and utf-8 on postgresql 8.1

by ottavio@[EMAIL PROTECTED] (Ottavio Campana) Apr 17, 2008 at 06:04 PM

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--
 




 2 Posts in Topic:
problem with tsearch and utf-8 on postgresql 8.1
ottavio@[EMAIL PROTECTED]  2008-04-17 18:04:50 
Re: problem with tsearch and utf-8 on postgresql 8.1
pavel.stehule@[EMAIL PROT  2008-04-17 19:08:27 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Mon Dec 1 19:39:06 CST 2008.