[postgis-users] ogr2ogr is looking for gesrid function

[Jose Carlos Martinez]

Hi,
ogr2ogr is not working to make a kml file from postgis. This error didnt 
happen before. Probably is an ogr postgis driver bug and not a postgis 
one but just in case Im posting in this list.


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....