[postgis-users] PostGIS 2.0.3 released

[Jerry Carter]

That helps clarify matters somewhat.  I appreciate that there can be multiple versions present in a PostgreSQL installation with individual databases using separate one.  The use of 'postgis_full_version()' makes sense at the database level.  

I am still confused, however, that PostgreSQL itself reports only 2.0.3 and not the previous version(s).  This is a clean upgrade of 9.2.3 so I would have expected to see Postgis 2.0.2 listed.


On Mar 1, 2013, at 11:48 AM, Sandro Santilli <strk at keybit.net> wrote:

> On Fri, Mar 01, 2013 at 11:36:35AM -0500, Jerry Carter wrote:
>> Minor question on the upgrade process and PostgreSQL extensions.  
>> 
>> When I built from source and upon the completion of 'make install', PostgreSQL reported [1] that version 2.0.3 was present BEFORE issuing the ALTER EXTENSION commands as advised in section 2.9.1.2 of the documentation.  Are the 'ALTER EXTENSION' commands really necessary?  If not, perhaps the documentation might suggest checking the version first.  If so, a warning in the documentation that the reported version doesn't match the installed version seems appropriate.
> ...
>> [1] SELECT "name",default_version,installed_version FROM pg_available_extensions WHERE "name" ILIKE 'postgis%'
> 
> The _presence_ of an extension (what you're querying) doesn't mean
> that extension is in use.
> 
> Use postgis_full_version() to know which version you're using.
> 
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users