Can You check if there is no change in proj parameters for Your projection ? You will find proj parameters in spatial_ref_sys table. Ivan
On Tuesday 26 May 2009, Miguel R. Luaces wrote: > The query should be: > > select nome, astext(the_geom), astext(transform(the_geom, 4326)) from > monumentos where id = 9; > > Copy-paste mistake. The problem still remains... > > Best regards, > Miguel > > On Tue, May 26, 2009 at 11:12 AM, Miguel R. Luaces > <[email protected]>wrote: > > > Dear all, > > > > we have a PostgreSQL 8.1 database with postgis 1.2 installed. We have some > > data in the database stored using EPSG:23029. > > > > We make a backup with pg_dump and we restore the database in PostgreSQL 8.2 > > with Postgis 1.3.1 without any problem. > > > > But, if we restore the backup in PostgreSQL 8.2 with Postgis 1.3.6, the > > function transform() returns a different result. More precisely: > > > > The same query: > > > > select astext(the_geom), astext(transform(the_geom)) from monumentos where > > id = , > > > > In Postgis 1.3.1: > > > > "Castelo de San Antón";"POINT(549556.009066526 > > 4801796.3531214)";"POINT(-8.38839299999999 43.3657910268222)" > > > > In Postgis 1.3.6: > > > > "Castelo de San Antón";"POINT(549556.009066526 > > 4801796.3531214)";"POINT(-8.38839299999999 43.3666118995462)" > > > > The second coordinate of the transformation to 4326 changes by 0.004 > > degrees (approx). > > > > Any idea? > > > > Thank you very much in advance. > > > > Best regards, > > Miguel > > > > > > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
