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

[Paul Ramsey]

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
also.

P.