<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.19597">
<STYLE>@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Verdana;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 2.0cm 70.85pt; }
P.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm; mso-fareast-language: EN-US
}
LI.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm; mso-fareast-language: EN-US
}
DIV.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm; mso-fareast-language: EN-US
}
SPAN.E-MailFormatvorlage17 {
FONT-FAMILY: "Calibri",sans-serif; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-FAMILY: "Calibri",sans-serif; mso-fareast-language: EN-US; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=DE style="WORD-WRAP: break-word" link=#0563c1 vLink=#954f72>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>Hi Hardy,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>did you copy / import the data from a previous (lower PostGIS
version) database ? </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>Possibly in that process you may have also added multiple
(additional and now obsolete) versions of the st_asgeojson function to the
public schema.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>You could verify that by running a query on the
function such as</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT size=2><FONT
color=#800000 face=Arial>select * from pg_proc where proname =
'st_asgeojson';</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>and compare that to a virgin installation of PostgreSQL
...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT size=2><FONT
color=#000080 face=Arial>In my case I have 5 entries for the 'st_asgeojson'
function for example</FONT></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>One way to fix this could be to remove the obsolete
versions of the function...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>A possible way of avoiding such trouble in the future would be
to avoid using the public schema for any of your project data and instead a
dedicated db schema for those, </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>then the functions would not be accidentally copied over to a
new database with a database dump ...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>Cheers</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=238433019-05012021><FONT color=#000080
size=2 face=Arial>Karsten</FONT></SPAN></DIV><BR>
<DIV lang=en-us class=OutlookMessageHeader dir=ltr align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> Mapbender_users
[mailto:mapbender_users-bounces@lists.osgeo.org] <B>On Behalf Of
</B>treckmann@gisme.de<BR><B>Sent:</B> Tuesday, January 05, 2021
08:18<BR><B>To:</B> mapbender_users@lists.osgeo.org<BR><B>Subject:</B>
[Mapbender-users] Setting Search Router fails<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN lang=EN-GB
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; BACKGROUND: white; COLOR: black'>Hi
all,</SPAN><SPAN lang=EN-GB
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; COLOR: black'><BR><SPAN
style="BACKGROUND: white">trying to setup a search like</SPAN><BR><SPAN
style="BACKGROUND: white">##########</SPAN><BR><SPAN
style="BACKGROUND: white">class:
Mapbender\CoreBundle\Component\SQLSearchEngine</SPAN><BR><SPAN
style="BACKGROUND: white">class_options:</SPAN><BR><SPAN
style="BACKGROUND: white"> connection: mydb</SPAN><BR><SPAN
style="BACKGROUND: white"> relation: mytable</SPAN><BR><SPAN
style="BACKGROUND: white"> attributes:</SPAN><BR><SPAN
style="BACKGROUND: white"> - gid</SPAN><BR><SPAN
style="BACKGROUND: white"> - text01</SPAN><BR><SPAN
style="BACKGROUND: white"> geometry_attribute: the_geom</SPAN><BR><SPAN
style="BACKGROUND: white">form:</SPAN><BR><SPAN style="BACKGROUND: white">
text01:</SPAN><BR><SPAN style="BACKGROUND: white"> type:
text</SPAN><BR><SPAN style="BACKGROUND: white">
options:</SPAN><BR><SPAN style="BACKGROUND: white">
required: false</SPAN><BR><SPAN style="BACKGROUND: white">
label: Nummer</SPAN><BR><SPAN style="BACKGROUND: white">
attr:</SPAN><BR><SPAN style="BACKGROUND: white">
data-autocomplete: 'on'</SPAN><BR><SPAN style="BACKGROUND: white">
compare: ilike</SPAN><BR><SPAN
style="BACKGROUND: white">results:</SPAN><BR><SPAN
style="BACKGROUND: white"> view: table</SPAN><BR><SPAN
style="BACKGROUND: white"> count: true</SPAN><BR><SPAN
style="BACKGROUND: white"> headers:</SPAN><BR><SPAN
style="BACKGROUND: white"> text01: Nummer</SPAN><BR><SPAN
style="BACKGROUND: white"> gid: bezeichnung</SPAN><BR><SPAN
style="BACKGROUND: white"> callback:</SPAN><BR><SPAN
style="BACKGROUND: white"> event: click</SPAN><BR><SPAN
style="BACKGROUND: white"> options:</SPAN><BR><SPAN
style="BACKGROUND: white"> buffer: 10</SPAN><BR><SPAN
style="BACKGROUND: white"> minScale: null</SPAN><BR><SPAN
style="BACKGROUND: white"> maxScale: 10000</SPAN><BR><SPAN
style="BACKGROUND: white"> styleMap:</SPAN><BR><SPAN
style="BACKGROUND: white"> ...</SPAN><BR><SPAN
style="BACKGROUND: white">###################</SPAN><BR><SPAN
style="BACKGROUND: white">The Table which holds the Geometries and the values
are epsg:25832 same as map definition</SPAN><BR><SPAN
style="BACKGROUND: white">When using I'm getting error in log
like:</SPAN><BR><SPAN style="BACKGROUND: white">....Funktion
st_asgeojson(geometry) ist nicht eindeutig....</SPAN><BR><SPAN
style="BACKGROUND: white">...</SPAN></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; BACKGROUND: white; COLOR: black'>HINT:
Konnte keine beste Kandidatfunktion auswählen. Sie müssen möglicherweise
ausdrückliche Typumwandlungen hinzufügen....</SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; COLOR: black'><BR><BR></SPAN><SPAN
lang=EN-GB
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; BACKGROUND: white; COLOR: black'>I'm
using PG 10.5 and PostGIS 2.5 on Windows 10 running x64</SPAN><SPAN lang=EN-GB
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; COLOR: black'><BR><SPAN
style="BACKGROUND: white">MapBender iversion is 3.2.3 installed with MS4W
(current release)</SPAN><BR><BR><SPAN style="BACKGROUND: white">Any
tip?</SPAN><BR><BR></SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; BACKGROUND: white; COLOR: black'>Regards</SPAN><SPAN
style='FONT-SIZE: 10pt; FONT-FAMILY: "Verdana",sans-serif; COLOR: black'><BR><SPAN
style="BACKGROUND: white">Hardy</SPAN></SPAN><o:p></o:p></P></DIV></BODY></HTML>