[postgis-users] DropGeometryColumn
David Blasby
dblasby at refractions.net
Thu Mar 18 10:54:22 PST 2004
strk wrote:
> I think it could be done applying a trigger from
> AddGeometryColumn(). Unfortunately the trigger(s) will
> have to be hooked on system tables, which postgresql guys
> does not like. You can nonetheless try that out and let
> us know.
strk,
DropGeometryColumn() should actually do an
ALTER TABLE <table> DROP COLUMN <column>;
The reason it doesnt is because postgresql 7.0 or 7.1 did NOT allow you
to do this. Since at least 7.2, we've been able to - we just havent
updated the function.
Could you change it so it does the DROP column instead of the sillyness
it does now?
dave
More information about the postgis-users
mailing list