[postgis-tickets] [PostGIS] #2503: ERROR: table "topology" is not a member of the extension being created

[PostGIS]

#2503: ERROR:  table "topology" is not a member of the extension being created
-----------------------------------+----------------------------------------
 Reporter:  strk                   |       Owner:  strk         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.1.1
Component:  build/upgrade/install  |     Version:  2.1.x        
 Keywords:  extension              |  
-----------------------------------+----------------------------------------

Comment(by robe):

 I think packaging the prior unpackaged with newer is out of the question
 since what is in packaged changes too much even across micros with hidden
 functions.  Because the unpackaged script has to include every
 function/type/etc/ that was packaged with that version.

 The correct way to upgrade to packaged is to
 1) Upgrade without extension (to bring you up to 2.1.1 or whatever)
 2) then run CREATE EXTENSION ... FROM unpackaged.

 Is topology schema in your search path?  I'm thinking those commands since
 (topology is always going to be in topology schema) should be prefixed
 with topology.

 Though that brings up the question of if you ran with just CREATE
 EXTENSION .. FROM unpackaged if it would run those scripts.  I don't think
 I have those in the unpackaged script, but probably should.


 {{{
 SELECT pg_catalog.pg_extension_config_dump('topology.topology', '');
 SELECT pg_catalog.pg_extension_config_dump('topology.layer', '');
 }}}

 They are for backup so should be in run when you are going from no
 extension to extension.

 the reason is because the table structures are never backed up and the
 data is only backed up if you have those commands.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2503#comment:7>
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.