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;
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
