On Fri, Mar 01, 2013 at 05:27:09PM -0500, Jerry Carter wrote: > 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.
Try querying pg_available_extension_versions or pg_extensions. See http://www.postgresql.org/docs/9.1/static/catalog-pg-extension.html I'm not an extension users as I find them to be more limited in what can or cannot be done, not sure "enabling" an older version of an extension is allowed, for example, but I know the same could be done with the non-extension scripts. --strk; _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
