I am just wondering why PostGIS does not create nee datatypes in a way that
allows a CREATE statement to make them. There is an example in the doc that
looks like this:
CREATE TABLE parks (
park_id INTEGER,
park_name VARCHAR,
park_date DATE,
park_type VARCHAR
);
SELECT AddGeometryColumn('parks', 'park_geom', 128, 'MULTIPOLYGON', 2 );
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)
);
Or something similar. Having to create the column as an after effect makes it
difficult to use PostGIS with database abstraction layers. Most of the good
DBALs allow the use of custom column types, however they do not usually support
post create statement column generation (maybe with an exception here or there
with ALTER TABLE commands).
Specifically I am looking into extending doctrine (a PHP DBAL/ORM) to utilize
spacial DBs.
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
