[postgis-users] ST_Transform error

[Sandro Santilli]

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