| From: | Mark Dilger <hornschnorter(at)gmail(dot)com> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | Craig Ringer <craig(at)2ndquadrant(dot)com>, Greg Stark <stark(at)mit(dot)edu>, David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Dave Page <dpage(at)pgadmin(dot)org>, Thom Brown <thom(at)linux(dot)com>, David Fetter <david(at)fetter(dot)org>, Jim Nasby <Jim(dot)Nasby(at)bluetreble(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Subject: | Re: 10.0 |
| Date: | 2016-06-20 16:28:02 |
| Message-ID: | 2B02C1AD-DB41-49F9-A819-48A45DF88966@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> On Jun 20, 2016, at 8:53 AM, Mark Dilger <hornschnorter(at)gmail(dot)com> wrote:
>
>
> This is not a plea for keeping the three part versioning system. It's just
> a plea not to have a 2 part versioning system masquerading as a three
> part versioning system, or vice versa.
To clarify my concern, I never want to have to write code like this:
CASE WHEN pg_version eq '11.1' OR pg_version eq '11.0.1' THEN foo()
WHEN pg_version eq '11.2' OR pg_version eq '11.0.2' THEN bar()
....
or
if (0 == strcmp(pg_version_string, "11.1") || 0 == strcmp(pg_version_string, "11.0.1"))
foo();
else if (0 == strcmp(pg_version_string, "11.2") || 0 == strcmp(pg_version_string, "11.0.2"))
bar();
either in sql, perl, c, java, or anywhere else. As soon as you have two different
formats for the version string, you get into this hell. Yeah, ok, you may have
a sql level function for this, but I'm thinking about applications somewhat removed
from a direct connection to the database, where you can't be sure which format
you'll be handed.
mark
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2016-06-20 16:38:14 | Re: 10.0 |
| Previous Message | Mark Dilger | 2016-06-20 16:26:44 | Re: 10.0 |