<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Stefan,<br>
<br>
postgis has (almost) nothing to do with PHP. Are you sure you are
using the right syntax for pgsql2shp connecting to a
postgis-extended postgresql when trying to export a postgis table
into a shape?<br>
<br>
Did you also try "<i>SELECT postgis_version();</i>" on your
database?<br>
<br>
Marco<br>
<br>
Am 06.12.2013 08:56, schrieb Stefan Schwarzer:<br>
</div>
<blockquote cite="mid:B36902B9-2608-45AA-B4C4-005BED272A2F@unep.org"
type="cite">
<div>Hi there,</div>
<div><br>
</div>
<div>we've upgraded our server from PHP 5.3.12 to 5.3.27… So, no
big deal. But I am not an admin-person, so don't understand what
else is needed.</div>
<div><br>
</div>
<div>But suddenly, I have problems with my PostGIS installation.
When I try to pgsql2shp, it says: </div>
<div><br>
</div>
<div><i><span class="Apple-tab-span" style="white-space:pre"> </span>ERROR:
function postgis_version() does not exist</i></div>
<div><br>
</div>
<div>The function still exists in the database.</div>
<div><br>
</div>
<div>Can this be related to the PHP upgrade? Or is that something
else?</div>
<div><br>
</div>
<div>When I launch the "<i>SELECT version() || '
' || postgis_full_version();</i>" I get this</div>
<div><br>
</div>
<div><i><span class="Apple-tab-span" style="white-space:pre"> </span>PostgreSQL
9.1.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.4.5-8) 4.4.5, 64-bit POSTGIS="2.0.0 r9605"
GEOS="3.3.3-CAPI-1.7.4" PROJ="Rel. 4.8.0, 6 March
2012" GDAL="GDAL 1.9.1, released 2012/05/15" LIBXML="2.7.8"
RASTER<br>
</i></div>
<div><br>
</div>
<div>Thanks for any hints,</div>
<div><br>
</div>
<div>Stefan</div>
<div><br>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
+++++++++++++++++++++++++++++++++
FOSSGIS 2014, Die Konferenz für Open Source GIS mit OpenData und OpenStreetMap!
19-21. März, Beuth HS für Technik, Berlin, <a class="moz-txt-link-freetext" href="http://www.fossgis.de/konferenz/2014/">http://www.fossgis.de/konferenz/2014/</a>
+++++++++++++++++++++++++++++++++
FOSSGIS e.V.
die unabhängige Hilfe bei freier GIS-Software und freien Geodaten
<a class="moz-txt-link-freetext" href="http://www.fossgis.de">http://www.fossgis.de</a>
+++++++++++++++++++++++++++++++++
</pre>
</body>
</html>