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

Marc G. Fournier scrappy at postgresql.org
Tue Jan 20 08:24:38 PST 2004


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

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



More information about the postgis-devel mailing list