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

[Martin Høgh]

Dear List,
I've moved a working postgis test db onto a production server and 
suddenly ran into an error.

"ERROR:  Can not mix dimensionality in a geometry"

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"

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,568861.86 6334089.98))',32632),4326) && 
the_geom and intersects(transform(GeometryFromText('POLYGON((568861.86 
6334089.98,572060.09 6334089.98,572060.09 6336265.82,568861.86 
6336265.82568861.86 6334089.98,568861.86 
6334089.98))',32632),4326),the_geom)

Why does it not work on the production server.

Best regards,

Martin
mapuse.net