[postgis-users] ST_Transform error

[Sandro Santilli]

On Tue, Jan 08, 2013 at 11:25:25AM +0100, Cedric Duprez wrote:
> >> I am on an Ubuntu 12.04 server.
> >> I uninstalled postgis extension 2.0.1, uninstalled postgis using make uninstall under the compiled sources directory.
> >> Then I uninstalled Proj4 in the same way, recompiled after having unzipped proj-datum grid 1.5 in the nad directory.
> >> Then I recompiled the new postgis 2.0.2 from sources and finally installed the extensions.
> >> 
> >> Have I done something wrong? How can I do to correct my installation?
> 
> >Actually it seems all fine to me.
> >Can you reproduce with any other SRID value ?
> 
> Yes, I can reproduce it with any other SRID values. Example:
> SELECT ST_X(g) AS x, ST_Y(g) AS y
> FROM (
> 	SELECT ST_Transform(ST_GeomFromText('POINT (2.017400 49.024761)', 4326), 27582) AS g
> ) AS req;
> I get the same error message: ERROR: lwgeom_transform: Cannot handle type 'Invalid type'
> État SQL :XX000
> 
> What should I do to perform a complete reinstallation from sources?

Can you reproduce droping the ST_GeomFromText call ?

 SELECT ST_X(g) AS x, ST_Y(g) AS y
 FROM (
   SELECT ST_Transform('SRID=4326;POINT (2.017400 49.024761)'::geometry, 27582) AS g
 ) AS req;

And with a simpler query ?

   SELECT ST_Summary('SRID=4326;POINT (2.017400 49.024761)'::geometry);

--strk;