[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