[postgis-users] update to 2.0.4

[Sandro Santilli]

On Tue, Sep 10, 2013 at 07:28:50PM +0200, Mario Jurcevic wrote:
> Hi,
> what is the correct way to upgrade from 2.0.3 to 2.0.4?
> 
> By running  postgis_upgrade_minor_2.0...
> gives error:
> 
> cannot drop function addgeometrycolumn(character varying,character
> varying,character varying,character varying,integer,character
> varying,integer,boolean) because extension postgis requires it
> HINT:  You can drop extension postgis instead.

That's because you evidently had PostGIS installed as an extension

> With "alter extension" gives no error but is everything updated?

It should. Check with

 SELECT postgis_full_version();

--strk;

 http://www.cartodb.com - Map, analyze and build applications with your data

                                       ~~ http://strk.keybit.net