transform geometry PostGIS column with unknown geometry type

[المشرف العام]

I run PostgreSQL 9.1 and PostGIS 2.0. I have a table that contains one geometry column.

But that column contains point, polygons lines, etc.

So I set it like so,

ALTER TABLE jake ADD COLUMN jake_geom geometry;

and then I setted some constraints to make it geometry enabled, but not limited on a single geometry type

ALTER TABLE jake ADD CONSTRAINT enforce_dims_geom CHECK (st_ndims(jake_geom) = 2);ALTER TABLE jake ADD CONSTRAINT enforce_srid_geom CHECK (st_srid(jake_geom) = 900913);Now, I want to reproject the geometries in that column to 4326.

According to this, for the transform to work, I need to set a geometry type.

(the TYPE geometry(MultiPolygon,2163) part)

but my column does not have certain geometry type. How do I proceed?

Or I can simply do

ALTER COLUMN geom USING ST_Transform(geom,2163);

avoiding to set a type?

Thanks



أكثر...