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

[alex bodnaru]

hi,

please note, that the lwpostgis.sql script, used to initialize a postgis
database, highly differs from postgresql 7.3 to 8.1.

thus, you might need to use the postgis upgrading procedure, described
in the manual. at large, you should strip all postgis own stuff from the
original database, and load the resulting script into a postgis enabled
database, created properly on the target system.

hope this will help,

alex

Frank Koormann wrote:
> 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
>