Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function ) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4] "permissions problem" with pl/pgsql function )
Date
Msg-id 24754.1074618462@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4]  ("Marc G. Fournier" <scrappy@postgresql.org>)
Responses Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4]  (Paul Ramsey <pramsey@refractions.net>)
List pgsql-hackers
"Marc G. Fournier" <scrappy@postgresql.org> writes:
> So, if we replace that with:
> ALTER TABLE table_name ALTER column_name DROP NOT NULL; ?
> should be good to go?  still not as clean as doing the straight DROP
> COLUMN, but its a fast fix ...

Yeah, that's what I'd do until the PostGIS guys can rethink things at a
higher level.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: PostGIS dropgeometrycolumn function (Was: Re: [7.4]
Next
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
Date:
Subject: Re: Old binary packages.