[Qgis-user] QGIS Webclient PostgreSQL search table

[Bernhard Ströbl]

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