Ticket #1518 (closed enhancement: wontfix)
Report SVN revision in PostGIS_Full_Version
|Reported by:||realityexists||Owned by:||pramsey|
It would be helpful if there was a way to find the exact PostGIS version, including the SVN revision it was built from, in SQL. PostGIS_Full_Version() reports "2.0.0SVN" or similar, but not the revision.
Sometimes our application relies on a particular bug fix, which we know was made in a particular revision. If an earlier version of PostGIS is used it may run for hours before failing, so I'd like to check the version at the start and fail immediately if it's not right. I currently do this by testing for the bug directly, but that kind of check doesn't really belong in production code. Checking the version would be simpler and cleaner.