[postgis-users] ogr2ogr is looking for gesrid function

[Sandro Santilli]

On Thu, Apr 12, 2012 at 05:00:09PM +0200, Jose Carlos Martinez wrote:

> alumno at linux-8hd6:/media/datoscurso/datos/dbf> ogr2ogr -f "KML"
> /tmp/ejemplo.kml PG:"host=localhost user=postgres dbname=s7" -dsco
> NameField=etiqueta -sql "Select etiqueta, geom from ej1.pusos,
> ej1.pusoscod where ej1.pusos.tuso = ej1.pusoscod.codigo_uso"
> ERROR 1: ERROR:  function getsrid(geometry) does not exist
> LINE 1: SELECT getsrid("geom") FROM (Select etiqueta, geom from ej1....

A newer OGR might have fixed this. Meanwhile load the legacy.sql 
file shipped with postgis.

--strk;

  ,------o-. 
  |   __/  |    Delivering high quality PostGIS 2.0 !
  |  / 2.0 |    http://strk.keybit.net - http://vizzuality.com
  `-o------'