On Mon, Jan 07, 2013 at 02:37:28PM +0100, Cedric Duprez wrote: > I have a little bit improved. First, I upgraded to Postgis 2.0.2 and > PostgreSQL 9.2.1.
[...] > SELECT *, ST_Transform(ST_SetSRID(ST_MakePoint(xl, yl), 910002), 910001) AS > geom > FROM (values (556866, 1902345) , (689174, 2448195) , (729095, 2528577) , > (335755, 2059702) , (623207, 2210468) , (850337, 1871486) , (915275, 1889534) > , (639551, 1778327) , (584365, 2273523) , (649599, 2228833)) as t(xl, yl); > > But I get the following error: "lwgeom_transform: Cannot handle type 'Invalid > type'" How did you upgrade ? The error sounds like due to a mixed use of old and new library functions. Try this query: select distinct p.probin from pg_proc p where p.probin like '%postgis%'; You should get only 2 rows. --strk; http://www.cartodb.com - Map, analyze and build applications with your data ~~ http://strk.keybit.net _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
