<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Am 25.06.2012 14:09, schrieb Bernhard Ströbl:
<blockquote cite="mid:4FE854F3.4090707@jena.de" type="cite">Hi
Dennis,
<br>
<br>
please try to execute SELECT to_tsvector('bla') in a SQL shell.
<br>
What happens?
<br>
Your error message indicates you call the funtion without an
argument.
<br>
Maybe you should read the doc on the Full text Search
<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.4/static/textsearch.html">http://www.postgresql.org/docs/8.4/static/textsearch.html</a>
<br>
and/or the tsvector data type
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.4/static/datatype-textsearch.html">http://www.postgresql.org/docs/8.4/static/datatype-textsearch.html</a>
<br>
<br>
Bernhard
<br>
<br>
Am 25.06.2012 13:11, schrieb Dennis Ströer:
<br>
<blockquote type="cite">Hello everybody,
<br>
<br>
I'm testing the QGIS webclient in the moment. Thanks for
developing such
<br>
a great project! Its a nice tool and the default settings and
<br>
functionality works fine. Now I'm trying to realize the search
with wsgi
<br>
and a PostgreSQL table setup for searching like explained in the
<br>
chapters 6 and 7 of the installation guide.
<br>
I created a searchtable and now I want to fill it with some test
data,
<br>
but a problem appears. When I want to fill the field
<br>
searchstring_tsvector with the value to_tsvector() I'm getting
the
<br>
following error:
<br>
<br>
ERROR: function to_tsvector() does not exist
<br>
<br>
I'm using PostgreSQL 8.4, so I think the tsearch package is
already
<br>
included?! And when I add a new column to a table I can select
the data
<br>
type tsvector...
<br>
<br>
Do I have to create the function to_tsvector by hand?
<br>
<br>
Does anybody know a solution for this error?
<br>
<br>
Cheers,
<br>
D. Stroeer
<br>
_______________________________________________
<br>
Qgis-user mailing list
<br>
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<br>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br>
<br>
<br>
</blockquote>
<br>
<br>
<br>
<br>
________ Information from NOD32 ________
<br>
This message was checked by NOD32 Antivirus System for Linux Mail
Server.
<br>
<a class="moz-txt-link-freetext" href="http://www.nod32.com">http://www.nod32.com</a>
<br>
</blockquote>
Hey guys,<br>
<br>
thanks for the quick response! <br>
Like Andreas told me, I executed the tsearch2.sql script which
installed the data types and function. If I execute SELECT
to_tsvector('bla') it returns 'bla' :1, so I think it works fine.<br>
<br>
But if I try to fill the searchtable, the same error message
appears: ERROR: function to_tsvector() does not exist<br>
<br>
Like Bernhard mentioned, it seems that I call the funtion without an
argument. But when I look at the example in the installation guide
on page 16, it seems to me, that I have to: <br>
<br>
<br>
CREATE TABLE public.searchtable<br>
(<br>
searchstring text, --the search string (all lower case), e.g. "z~ 1
richstrasse 46, 8610 uster"<br>
<br>
displaytext text NOT NULL, --the display text for the search
combobox, e.g. "Z~ 1 richstrasse 46, 8610 Uster (address<br>
<br>
search_category text, --should have a leading two digit number:,
e.g.<br>
--"03_parcels", where 03 is the order of the search categories, the
number<br>
--should be unique across all search tables<br>
the_geom geometry,<br>
--the actual geometry<br>
geometry_type text,<br>
--the geometry type as returned by ST_GeometryType(the_geom)<br>
searchstring_tsvector tsvector, <b>-- be sure to fill this with
to_tsvector()</b><br>
CONSTRAINT searchtable_pkey PRIMARY KEY (displaytext)<br>
)<br>
WITH (<br>
OIDS=FALSE<br>
);<br>
<br>
<br>
Cheers,<br>
D. Stroeer<br>
</body>
</html>