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 robe, 13 years ago

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.

comment:2 by Bborie Park, 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 robe, 13 years ago

Resolution: fixed
Status: newclosed

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.

Note: See TracTickets for help on using tickets.