Re: querying the version of libpq - Mailing list pgsql-general

From Tom Lane
Subject Re: querying the version of libpq
Date
Msg-id 26161.1286296883@sss.pgh.pa.us
Whole thread Raw
In response to Re: querying the version of libpq  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Responses Re: querying the version of libpq
Re: querying the version of libpq
Re: querying the version of libpq
List pgsql-general
Peter Geoghegan <peter.geoghegan86@gmail.com> writes:
> On 5 October 2010 16:33, Greg Sabino Mullane <greg@turnstep.com> wrote:
>>> How does the driver figure it out?
>>
>> DBD::Pg parses pg_config --version, then passes the information
>> to the C programs for directive fiddling. I certainly hope
>> other drivers are doing the same, as libpq varies across
>> major versions a good deal.

> I would imagine that most libpq wrapping drivers use libpq's
> PQserverVersion(), which returns an integer that looks like 90000.

The real problem is that neither of these can be trusted to tell you the
*library* version.  PQserverVersion() is something else altogether,
and I wouldn't want to assume that pg_config exactly matches the library
you're linked to --- if it's even present at all.

We could add a PQlibpqVersion(), maybe, but it would be many years
before client code could rely on that being present.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: psql \q hang
Next
From: John R Pierce
Date:
Subject: Re: Trying to figure out why these queries are so slow