[postgis] inserting MultiPolygons

[Dave Blasby]

> CREATE TABLE SITE_BOUNDARY (
>         Boundary_id             DOUBLE PRECISION NOT NULL
>         CONSTRAINT PK_SITE_BOUNDARY PRIMARY KEY,
>         External_Boundary       POLYGON[] NOT NULL,
>         Site_Centroid           POINT NOT NULL
> );
> 

I think you're trying to use the standard postgresql geometry types. 
For example,
POLYGON[] means a list of the old-type polygons - NOT PostGIS polygons
(GEOMETRY).  You should
be using the AddGeometryColumn() function to create a geometry column.  

See the documentation at postgis.refractions.net.


dave

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/