Problems of connexion with Tsearch2 functions
От | Séverine Gedzelman |
---|---|
Тема | Problems of connexion with Tsearch2 functions |
Дата | |
Msg-id | 46938C4D.7040701@evodia.fr обсуждение исходный текст |
Список | pgsql-general |
I am a beginner with Postgresql and Full-Text indexing enabled by Tsearch2. I have recently set all the configuration to run Tsearch2 on my databases (Postgresql 8.2), under Linux (Fedora). Everything worked great for a period of time. The queries I frequently used were : - select finddoc('word') - a special query using the function to_tsquery - select lexize('word') Then today, all the queries that call a Tsearch2 function, instanteanously breaks the connection to the base, failing the query of course. 1) Example when attempting the query from a Xterminal (french version) # select set_curdict('fr_ispell'); La connexion au serveur a été coupée à l'improviste Le serveur s'est peut-être arrêté anormalement avant ou durant le traitement de la requête. La connexion au serveur a été perdue. Tentative de réinitialisation : Echec. 2) Example when attempting from our JAVA Application (english version) # The backend has broken the connection. Possibly the action you have attempted has caused it to close. at org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:140) at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:76) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:183) Queries like the following work just fine, # select count(*) from table ; So what is the problem really ? Anyone experienced something like this before with Tsearch2 ? Should I reinstall Tsearch2 completely in Postgresql ? I have already applied 'uninstall_tsearch2.sql' on my base, but it does not change anything Thanks you for advise, hope someone can help. S.G.
В списке pgsql-general по дате отправления: