[postgis-devel] DROPGEOMETRYCOLUMN() in 0.8.1 ...

[strk]

scrappy wrote:
> 
> Does anyone happen to have an updated version for 7.4?  According to the
> comments on this, at the top:
> 
> -- There is no ALTER TABLE DROP COLUMN command in postgresql
> -- There is no ALTER TABLE DROP CONSTRAINT command in postgresql
> 
> But these both exist in 7.4 ...

PostGIS 0.8.1 should actually issue an ALTER TABLE DROP COLUMN
when built against postgres 7.3 or 7.4. I changed that when
adding schema support.  Please let me know if this is not the case.

--strk;

> The problem is that the function, as written, can only work if you are
> connecting to the database as the superuse, and in the case of one of my
> clients trying to use PostGis, he doesn't have that level of access, so
> its failing for him :(
> 
> In fact, checking the 7.3 documentation, both the DROP COLUMN and
> CONSTRAINT were available there also ...
> 
> Thanks ...
> 
> ----
> Marc G. Fournier           Hub.Org Networking Services (http://www.hub.org)
> Email: scrappy at hub.org           Yahoo!: yscrappy              ICQ: 7615664
> 
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel