Detecting Postgres version during build

[Tom Hughes]

On 07/03/12 10:45, Gianluca Sforna wrote:

> On Wed, Mar 7, 2012 at 11:32 AM, Tom Hughes<tom at compton.nu>  wrote:
>> It might be worth looking at how something like the postgis package handles
>> this, as it also contains a Postgres extension.
>
> Yeah. useful:
> http://pkgs.fedoraproject.org/gitweb/?p=postgis.git;a=blob;f=postgis.spec;h=53c558366da23ea5afdec41331b3ed40b0138c72;hb=HEAD
>
> It seems it uses an approach similar to what Rich suggested to check
> version. It also seems to build for/against a single postgresql
> version, adding an explicit require for the same version (not sure how
> you can end up with a mismatch tough, maybe on upgrades?)

Postgis does include 3GL functions that are installed into postgres so 
will be fairly closely tied to the postgres version it was compiled 
against anyway.

If what you're dealing with is pure SQL then it may be less closely tied 
to a specific version that postgis is.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://compton.nu/