How to let the table allow both polygon and multipolygon?
I create geometry column use SELECT AddGeometryColumn
('','china_block','geom',4326,'POLYGON',2);
I tried SELECT AddGeometryColumn ('','mytable','geom',4326,'MULTIPOLYGON',2);
it says
ERROR: column "geom" of relation "china_block" already exists
CONTEXT: SQL statement "ALTER TABLE public.china_block ADD COLUMN
geom geometry "
PL/pgSQL function "addgeometrycolumn" line 121 at EXECUTE statement
SQL statement "SELECT AddGeometryColumn('', $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "addgeometrycolumn" line 4 at SQL statement
As you suggested, I can change POLYGON to MULTIPOLYGON.
But if the column has LINESTRING and POLYGON, what should I do?
thanks.
2010/4/13 Stephen Woodbridge <[email protected]>:
> Li Li wrote:
>>
>> I have a table from oracle. a spatial column geom is SDO_GEOMETRY. I
>> migrated it to postgis. this geom column has record with type of
>> POLYGON and MULTIPOLYGON. is there any common type that can store any
>> geometry?
>
> The common type in PostGIS is "geometry", but you can also change the
> constraints you table to allow both POLYGON and MULTIPOLYGON.
>
> Or you can do something like:
>
> update mytable set the_geom = ST_Multi(the_geom)
> where ST_GeometryType = "POLYGON';
>
> -Steve W
> _______________________________________________
> postgis-users mailing list
> [email protected]
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
