Ticket #1563 (closed defect: fixed)

Opened 15 months ago

Last modified 15 months ago

Can't upgrade from alpha3 to alpha4 with extension

Reported by: robe Owned by: robe
Priority: blocker Milestone: PostGIS 2.0.0
Component: build/upgrade/install Version: trunk
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

Changed 15 months ago by robe

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.

Changed 15 months ago by dustymugs

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.

Changed 15 months ago by robe

  • status changed from new to closed
  • resolution set to fixed

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.