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 [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
