Opened 13 years ago
Closed 13 years ago
#1563 closed defect (fixed)
Can't upgrade from alpha3 to alpha4 with extension
Reported by: | robe | Owned by: | robe |
---|---|---|---|
Priority: | blocker | Milestone: | PostGIS 2.0.0 |
Component: | build | Version: | master |
Keywords: | Cc: |
Description
I thought this was something I handled already, but might have gotten taken out by accident. Where I drop all functions from extension to prevent this error since we add functions with create or replace anyway so they would get readded.
ALTER EXTENSION postgis UPDATE TO "2.0.0alpha4";
Fails with:
cannot drop function addgeometry column .. because extension postgis requires it.
Change History (3)
comment:1 by , 13 years ago
comment:2 by , 13 years ago
That'd be my fault. When I added the out_db boolean column I put it in the spot where the extent geometry column was and put extent at the end of the column list. So, feel free to undo that. I just wanted a clean structure for the future. Sorry.
comment:3 by , 13 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Fixed at r9138. I went with dropping it from the extension. It will be readded anyway during recreation so harmless to and gets rid of the dependency issue.
Took care of the first issue at r9132.
But now get another obstacle of CAN'T drop raster_columns view because postgis extension depends on it.
GUYS you don't need to drop a view if you are adding a column at the end -- CREATE OR REPLACE VIEW can handle that. It just can't handle data type changes.