[postgis-users] Wondering why I can't use the geometry type in a CREATE statement.

Paul Ramsey pramsey at opengeo.org
Sun Jun 27 23:21:54 PDT 2010

On Sun, Jun 27, 2010 at 7:03 PM, Greg Militello <junk at thinkof.net> wrote:
> Why isn't this possible?
> CREATE TABLE parks (
>  park_id    INTEGER,
>  park_name  VARCHAR,
>  park_date  DATE,
>  park_type  VARCHAR,
>  parks   GEOMETRY(128, 'MULTIPOLYGON', 2)
> );

Until recently (pgsql 8.3), PostgreSQL didn't support 'typemod' values
(that stuff after the type name) for custom types. But now it does.
You can see them in action in the GEOGRAPHY type added in 1.5. Since
the concept is now proved, in 2.0, we will support typemod on GEOMETRY


More information about the postgis-users mailing list