[postgis-users] ogr2ogr is looking for gesrid function

[Jose Carlos Martinez]

Thanks Sandro, after loading legacy.sql it is working.
This list is great! I cant believe how fast you guys solve the problems.
Best,
Jose


On 12/04/2012 17:14, Sandro Santilli wrote:
> 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------'
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users