[postgis-users] PostGIS 2.0.3 released

[Sandro Santilli]

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;