[postgis-users] Error while importing data

[Stephen Woodbridge]

Markus Schaber wrote:
> Hi, Nigel,
> 
> strk at refractions.net schrieb:
> 
> 
>>>would this affect mapserver btw? I'm up to try and experiment anything,
>>>and help where I can.
>>
>>About mapserver you shouldn't have any problem as all geometries are
>>converted to 2d before parsing anyway, I don't think it uses
>>the 'dimension' field of geometry_columns at all.
> 
> 
> For mapserver, it could even benefit if you run your geometries through
> force_2d in an update, and then VACUUM FULL ANALYZE the table. This way
> you avoid reading and transmitting the data to mapserver only to have it
> thrown away there.

So, just to confirm that I understand this correctly, I would run:

UPDATE mytable SET the_geom = force_2d(the_geom);
VACUUM FULL ANALYZE mytable;

to get all my geometry in mytable to be 2D.

-Steve