[postgis-users] Getting "function postgis_version() does not exist" after PHP upgrade

[Marco Lechner - FOSSGIS e.V.]

Hi Stefan,

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?

Did you also try "/SELECT postgis_version();/" on your database?

Marco

Am 06.12.2013 08:56, schrieb Stefan Schwarzer:
> Hi there,
>
> 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.
>
> But suddenly, I have problems with my PostGIS installation. When I try
> to pgsql2shp, it says: 
>
> /ERROR:  function postgis_version() does not exist/
>
> The function still exists in the database.
>
> Can this be related to the PHP upgrade? Or is that something else?
>
> When I launch the "/SELECT version() || '
> ' || postgis_full_version();/" I get this
>
> /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
> /
>
> Thanks for any hints,
>
> Stefan
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


-- 
+++++++++++++++++++++++++++++++++
FOSSGIS 2014, Die Konferenz für Open Source GIS mit OpenData und OpenStreetMap!
19-21. März, Beuth HS für Technik, Berlin, http://www.fossgis.de/konferenz/2014/
+++++++++++++++++++++++++++++++++
FOSSGIS e.V.

die unabhängige Hilfe bei freier GIS-Software und freien Geodaten
http://www.fossgis.de
+++++++++++++++++++++++++++++++++

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131206/272ddc9e/attachment.html>