<div dir="ltr">Hi Das,<div><br></div><div><div>I had to look three times to your email to notice the tricky difference between <i style="line-height:1.5">LWGEOMFromWKB and </i><code>geomfromewkb()</code><span style="line-height:1.5"> (notice the extra 'e'?) </span></div></div><div><span style="line-height:1.5">Seems you're trying to import an dump from an older version of postgis (1.5?) into a newer 2.2 version. There will be a lot more problems than only these messages like that.</span><br></div><div><br></div><div>Please follow these instructions on doing a hard-upgrade (or upgrade the hard way ;-) </div><div><a href="http://www.postgis.org/docs/postgis_installation.html#hard_upgrade">http://www.postgis.org/docs/postgis_installation.html#hard_upgrade</a><br></div><div><br></div><div>Best,</div><div> Tom</div><div><span style="line-height:1.5"><br></span></div></div><br><div class="gmail_quote"><div dir="ltr">On Thu, 21 Jan 2016 at 15:44 Dasaraden MAUREE <<a href="mailto:dasaraden.mauree@gmail.com">dasaraden.mauree@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div class="gmail_quote">Subject: GEOMfromEWKB missing<br><br><div dir="ltr">I am quite new to <code>psql</code> and I am trying to carry on a work that has been started by someone else and I am trying to import an sql dump he made, and I am having the following errors:<br><br><i>psql:nameofdatabase.sql:3847: ERROR: could not find function "LWGEOMFromWKB" in file "/usr/lib/postgresql/9.3/lib/<a href="http://postgis-2.2.so" target="_blank">postgis-2.2.so</a>"<br> psql:nameofdatabase.sql:3850: ERROR: function postgis.geomfromewkb(bytea) does not exist</i><blockquote>
</blockquote>
<p>It seems to me from the <code>\df</code> command that the <code>geomfromewkb()</code> function is here but is in the <code>public</code> schema. This should not be a problem then for psql to find it right, since when I do</p>
<pre><code><span>SHOW search_path</span><span>;</span><span>
</span><span>public</span><span>,$</span><span>user</span><span>,</span><span>data</span><span>,</span><span>tiger <br></span></code></pre>
<p>are here.</p><p><br></p><p>Once I will be able to import the DB, I want to run a Java script to extract some info. from there.</p><p>One of the errors I get is:</p><p><i>org.postgresql.util.PSQLException: ERROR: function st_contains(postgis.geometry, postgis.geometry) does not exist<br> Hint: No function matches the given name and argument types. You might need to add explicit type casts.</i><br></p><p>I don't understand again why I have these errors when these functions seems to be present in the DB.</p><p></p><p><br></p><p></p>
<p>Does anyone know about these and can tell me how I can fix this?</p><p></p><p>Thanks,</p><p></p><p>Das<br></p></div><br></div><br><br clear="all"><br>-- <br><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Dasaraden MAUREE<br>--<br><div>Docteur de l'Université de Strasbourg</div><div><br></div><div>Post-Doctoral Research Fellow<br></div><div>Ecole Polytechnique Fédérale de Lausanne<br></div><div>Laboratoire d'Energie Solaire et de Physique du Bâtiment<br></div><div>LE 1 103 (Bâtiment LE)<br>Station 18<br></div><div>CH - 1015 Lausanne<br>Suisse<br></div><div><span style="color:rgb(0,0,0)"><br>+41 21 693 55 56<br><br></span><span style="color:rgb(0,0,0)">@D_Mauree<br><br><a href="https://sites.google.com/site/dasaradenmauree/" target="_blank"><img alt="https://sites.google.com/site/dasaradenmauree/" src="http://api.qrserver.com/v1/create-qr-code/?color=000000&bgcolor=FFFFFF&data=https%3A%2F%2Fsites.google.com%2Fsite%2Fdasaradenmauree%2F&qzone=1&margin=0&size=400x400&ecc=L" height="96" width="96"></a></span><span style="color:rgb(0,0,0)"><br></span></div></div></div></div></div></div></div>
</div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>