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

PostGIS trac at osgeo.org
Thu Nov 7 04:23:02 PST 2013


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

Comment(by robe):

 That doesn't make much sense to me.  The unpackaged scripts are already
 versioned.


 {{{
 CREATE EXTENSION postgis FROM unpackaged VERSION '2.2.0dev';
 }}}

 means run postgis--unpackaged--2.2.0dev.sql

 What you are proposing would create a version that is not upgradeable
 without adding a lot more dupes.

 The best way to upgrade which I think which I outlined in the docs in
 section


 http://postgis.net/docs/manual-2.1/postgis_installation.html#make_install_postgis_extensions


 Is if you started off without installing using extensions, then you
 1. Upgrade without extensions

 2. then you run the unpackaged step -- which always defaults to the latest
 installed postgis version.


 The reason for doing it that way as opposed to first install from
 unpackaged version ... is that the unpackaged version ... has to exist,
 and if your distro package is super anal, they would have uninstalled the
 older version, before giving you the newer version, thus making it
 impossible to upgrade that way.

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


More information about the postgis-tickets mailing list