[postgis-users] ST_Transform error

[Sandro Santilli]

On Tue, Jan 08, 2013 at 03:04:21PM +0100, Cedric Duprez wrote:
> >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);
> 
> OK, the first query gave me the same error (lwgeom_transform: Cannot handle type 'Invalid type')
> The second one gives: Point[S]

Uhm, what about:

select n.nspname, p.proname, p.prosrc, p.probin from pg_proc p, pg_type t, pg_namespace n where p.pronamespace = n.oid and p.proargtypes[0] = t.oid and t.typname = 'geometry' and proname = 'st_transform';

You may also keep trying to simplify the case, ie:

 SELECT ST_Transform('SRID=4326;POINT(0 0)'::geometry, 27582) 
 SELECT ST_Transform('SRID=4326;POINT(0 0)'::geometry, 4326) 

--strk;