Re: [JDBC] Setting PG-version without recompiling

Lists: pgsql-hackerspgsql-jdbc
From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>
Subject: Setting PG-version without recompiling
Date: 2014-07-03 09:02:34
Message-ID: VisenaEmail.4d.163a4cd26e72b9d3.146fb741d54@tc7-on
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

Hi.   I'm up for testing 9.4 but my JDBC-driver fails to connect due to PG's
minor-version string: "4beta1". Is it possible to set this somewhere without
recompiling PG?   Thanks.   -- Andreas Jospeh Krogh CTO / Partner - Visena AS
Mobile: +47 909 56 963 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com> <https://www.visena.com>

From: Abhijit Menon-Sen <ams(at)2ndQuadrant(dot)com>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Setting PG-version without recompiling
Date: 2014-07-03 09:13:44
Message-ID: 20140703091344.GH10574@toroid.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

At 2014-07-03 11:02:34 +0200, andreas(at)visena(dot)com wrote:
>
> Is it possible to set this somewhere without
> recompiling PG?

I'm afraid not.

-- Abhijit

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Setting PG-version without recompiling
Date: 2014-07-03 09:35:04
Message-ID: VisenaEmail.54.a995c6b809309cd8.146fb939833@tc7-on
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

På torsdag 03. juli 2014 kl. 11:13:44, skrev Abhijit Menon-Sen <
ams(at)2ndQuadrant(dot)com <mailto:ams(at)2ndQuadrant(dot)com>>: At 2014-07-03 11:02:34
+0200, andreas(at)visena(dot)com wrote:
>
> Is it possible to set this somewhere without
> recompiling PG?

I'm afraid not.   Ok   -- Andreas Jospeh Krogh CTO / Partner - Visena AS
Mobile: +47 909 56 963 andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com> <https://www.visena.com>  

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Setting PG-version without recompiling
Date: 2014-07-03 14:16:01
Message-ID: 21060.1404396961@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

Andreas Joseph Krogh <andreas(at)visena(dot)com> writes:
> Hi. I'm up for testing 9.4 but my JDBC-driver fails to connect due to PG's
> minor-version string: "4beta1". Is it possible to set this somewhere without
> recompiling PG?

No, and even if you could, that would be the wrong approach. The right
approach is to fix the JDBC driver to not complain about such version
strings. I'm a bit surprised they haven't done so long since, considering
how long PG beta versions have been tagged like that. For that matter,
they really ought not complain about strings like "9.5devel" or
"9.5alpha2" either.

regards, tom lane

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Setting PG-version without recompiling
Date: 2014-07-03 15:54:05
Message-ID: VisenaEmail.8e.793040bdcbd63e18.146fcbb2cbb@tc7-on
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

På torsdag 03. juli 2014 kl. 16:16:01, skrev Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>>: Andreas Joseph Krogh <andreas(at)visena(dot)com> writes:
> Hi. �� I'm up for testing 9.4 but my JDBC-driver fails to connect due to
PG's
> minor-version string: "4beta1". Is it possible to set this somewhere without
> recompiling PG?

No, and even if you could, that would be the wrong approach.  The right
approach is to fix the JDBC driver to not complain about such version
strings.  I'm a bit surprised they haven't done so long since, considering
how long PG beta versions have been tagged like that.  For that matter,
they really ought not complain about strings like "9.5devel" or
"9.5alpha2" either.

regards, tom lane   I'm using the pgjdbc-ng driver, I'm sure the "official"
driver handles this. The driver will be fixed (the issue has a pull-request), I
just wondered if there was a magic know I could use until the PR is merged.   --
Andreas Jospeh Krogh CTO / Partner - Visena AS Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com> www.visena.com
<https://www.visena.com> <https://www.visena.com>  

From: Craig Ringer <craig(at)2ndquadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andreas Joseph Krogh <andreas(at)visena(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [JDBC] Setting PG-version without recompiling
Date: 2014-07-14 03:47:10
Message-ID: 53C352BE.6040807@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers pgsql-jdbc

On 07/03/2014 10:16 PM, Tom Lane wrote:
> Andreas Joseph Krogh <andreas(at)visena(dot)com> writes:
>> Hi. Â I'm up for testing 9.4 but my JDBC-driver fails to connect due to PG's
>> minor-version string: "4beta1". Is it possible to set this somewhere without
>> recompiling PG?
>
> No, and even if you could, that would be the wrong approach. The right
> approach is to fix the JDBC driver to not complain about such version
> strings. I'm a bit surprised they haven't done so long since, considering
> how long PG beta versions have been tagged like that. For that matter,
> they really ought not complain about strings like "9.5devel" or
> "9.5alpha2" either.

Yeah, that's horrible. We should be using server_version_num .

It should be a quick enough fix, I'll take a look.

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services