Hi Dennis,

please try to execute SELECT to_tsvector('bla') in a SQL shell.
What happens?
Your error message indicates you call the funtion without an argument.
Maybe you should read the doc on the Full text Search
http://www.postgresql.org/docs/8.4/static/textsearch.html
and/or the tsvector data type http://www.postgresql.org/docs/8.4/static/datatype-textsearch.html

Bernhard

Am 25.06.2012 13:11, schrieb Dennis Ströer:
Hello everybody,

I'm testing the QGIS webclient in the moment. Thanks for developing such
a great project! Its a nice tool and the default settings and
functionality works fine. Now I'm trying to realize the search with wsgi
and a PostgreSQL table setup for searching like explained in the
chapters 6 and 7 of the installation guide.
I created a searchtable and now I want to fill it with some test data,
but a problem appears. When I want to fill the field
searchstring_tsvector with the value to_tsvector() I'm getting the
following error:

ERROR: function to_tsvector() does not exist

I'm using PostgreSQL 8.4, so I think the tsearch package is already
included?! And when I add a new column to a table I can select the data
type tsvector...

Do I have to create the function to_tsvector by hand?

Does anybody know a solution for this error?

Cheers,
D. Stroeer
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user






________ Information from NOD32 ________
This message was checked by NOD32 Antivirus System for Linux Mail Server.
http://www.nod32.com
_______________________________________________
Qgis-user mailing list
Qgis-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to