[Qgis-user] QGIS Webclient PostgreSQL search table

Dennis Ströer dennis.stroeer at geosysnet.de
Mon Jun 25 04:11:56 PDT 2012


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



More information about the Qgis-user mailing list