dblasby at refractions.net
Fri Mar 19 10:20:06 PST 2004
Sorry, strk, I had forgotten you'd already made the DROP COLUMN patch
for 7.3 and above patch.
> On Thu, Mar 18, 2004 at 10:54:22AM -0800, David Blasby 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
>>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?
> The ALTER TABLE .. DROP COLUMN support appears in
> the PostgreSQL documentation only since version 7.3, see:
> The SQL code should already be correct for PG>=73.
> ( since late december )
> Please let me know if pgsql dox are broken/outdated.
> postgis-users mailing list
> postgis-users at postgis.refractions.net
More information about the postgis-users