[postgis-users] Can not mix dimensionality in a geometry

[Frank Koormann]

Hi Martin,

* Martin Høgh <mh at svaj.dk> [060113 16:17]:
> The version of production server:
> 
> "PostgreSQL 8.1.2 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 
> 3.4.2 (mingw-special)"
> "1.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
> 
> The version of test server:
> "PostgreSQL 7.3.4-RH on i386-redhat-linux-gnu, compiled by GCC 
> i386-redhat-linux-gcc (GCC) 3.3.2 20031022 (Red Hat Linux 3.3.2-1)"
> "0.8 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"

To be honest: That doesn't seem to be a reasonable setting of test
server/production server to me. The combination of numerous
versions/platforms raises the chances to run into problems such as you
encountered:

> And the query that cause the error:
> 
> select asText(transform(the_geom,32632)) as geometry,gid,* from wpt 
> where transform(GeometryFromText('POLYGON((568861.86 
> 6334089.98,572060.09 6334089.98,572060.09 6336265.82,

> 568861.86 6336265.82568861.86 6334089.98,
[...]
> 
> Why does it not work on the production server.
> 

This seems to be the problem: A comma is missing. While the PostGIS 0.8
on your test system by some means ignores this error the version 1.0 on
your production server is more strict about this. 

Best regards,

        Frank

-- 
Frank Koormann                             <frank.koormann at intevation.de>
 Professional Service around Free Software       (http://intevation.net/)
 FreeGIS Project                                 (http://freegis.org/)