[postgis-devel] [PostGIS] #1637: rtpostgis_upgrade_20_minor.sql doesn't work

[PostGIS]

#1637: rtpostgis_upgrade_20_minor.sql doesn't work
------------------------------------+---------------------------------------
  Reporter:  nicklas                |       Owner:  strk         
      Type:  defect                 |      Status:  closed       
  Priority:  medium                 |   Milestone:  PostGIS 2.0.0
 Component:  build/upgrade/install  |     Version:  trunk        
Resolution:  invalid                |    Keywords:               
------------------------------------+---------------------------------------
Changes (by robe):

  * status:  new => closed
  * resolution:  => invalid


Comment:

 Nicklas,
 Nice to see you back in the groove again :).

 As strk said sounds like your postgis was installed with extensions.  You
 can't upgrade an extension installed postgis with the scripts, you have to
 use


 {{{
 ALTER EXTENSION postgis  UPDATE TO ..
 }}}


 http://www.postgresql.org/docs/devel/static/sql-alterextension.html

 Sadly extension updates have to be done at version milestones since your
 from and to can't be the same version so you'll need to wait till pramsey
 releases the next release today.

 However that said -- there is an issue with the update scripts for
 extension which I have noted in http://trac.osgeo.org/postgis/ticket/1630
 which I hope to fix before beta comes out today.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1637#comment:2>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.