[postgis-users] Reducing geometry type's dimensions

[Aren Cambre]

I was trying to copy a geometry data type from one table to another, but I
got a *enforce_dims_the_geom* error.

I looked at the *geometry_columns* table, and turns out the source table has
a 4-dimensional field and the destination table has a 2-dimensional field.
Both fields have srid 3081, and they are both of type point.

The source table is an import from a SHP using shp2pgsql, so I guess the
4-dimensionality was created at import time? I don't know why it's 4
dimensions; all its points only exist in a 2-dimensional plane.

How can I remove the two extraneous dimensions while I copy this geometry
object from one table to another?

Aren
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110828/49db0593/attachment.html>