Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YJbqh-00062T-Dw for pgsql-docs@arkaria.postgresql.org; Fri, 06 Feb 2015 05:53:03 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YJbqg-0004zv-5g for pgsql-docs@arkaria.postgresql.org; Fri, 06 Feb 2015 05:53:02 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YJbqf-0004zp-Fx for pgsql-docs@postgresql.org; Fri, 06 Feb 2015 05:53:01 +0000 Received: from mail-oi0-f48.google.com ([209.85.218.48]) by magus.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YJbqb-0007mG-Eb for pgsql-docs@postgresql.org; Fri, 06 Feb 2015 05:53:00 +0000 Received: by mail-oi0-f48.google.com with SMTP id u20so7395864oif.7 for ; Thu, 05 Feb 2015 21:52:55 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:date:message-id:subject:from:to :content-type; bh=fgTyzr+sBN6oZwxr1flFMrLniPl4CA2BCyuZOMlBwMI=; b=eoZBafmOkLAv2bW+iCbOJr/2vp7P+bnBfm8d+Pc3CXtp5kiRRY3Lfz1TuhKVczAkT9 JRl2QOWSC+pnN+bdi8bF1oiTsKL+/nXvZUubC/nmma7p1cyAzVPsilt/FUj7Nl/+lm2V dmo6QSfRQ6xT7utjGskSBnfXQWUk0wlYtlRvtvDDIOkmExOy5hzVADMpa1aUTHRYlTGw ZgmmXHhgnxyTMmPjsRYrbQkgmsQvW8TSBgyNaZsUmP+r5h3+In1x3R6SSNoGwAT74XIu a+1cCkO/Y++RF8Y1Qv8rYSG2RDymsMdUiSAulKBdnhjOpnOkVrBXwaLptmyYYEbcxVHS ru7w== X-Gm-Message-State: ALoCoQnIGFwMXrfiaPVVlH5Piu2u5QPPxAFSkkiey4s196x/q+ldWhJcwGsuDbuSKMSDHkuWp3XH MIME-Version: 1.0 X-Received: by 10.202.173.194 with SMTP id w185mr1239081oie.30.1423201975089; Thu, 05 Feb 2015 21:52:55 -0800 (PST) Received: by 10.76.18.138 with HTTP; Thu, 5 Feb 2015 21:52:54 -0800 (PST) Date: Fri, 6 Feb 2015 16:52:54 +1100 Message-ID: Subject: [PATCH] Advise devs to prefer server_version_num over parsing the version From: Craig Ringer To: pgsql-docs@postgresql.org Content-Type: multipart/mixed; boundary=001a113ceca02b8749050e6508c5 X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-docs Precedence: bulk Sender: pgsql-docs-owner@postgresql.org --001a113ceca02b8749050e6508c5 Content-Type: multipart/alternative; boundary=001a113ceca02b8740050e6508c3 --001a113ceca02b8740050e6508c3 Content-Type: text/plain; charset=UTF-8 We've had server_version_num since 8.2. Advise devs to prefer to use it instead of parsing version() or server_version . -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services --001a113ceca02b8740050e6508c3 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
We've had server_version_num since 8.2.

Advise devs to prefer to use it instead of parsing version() or server_= version .

--
=C2=A0Craig Ringer=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 http://www.2ndQuadrant.com/
=C2=A0PostgreSQL Development, 24x7 = Support, Training & Services
--001a113ceca02b8740050e6508c3-- --001a113ceca02b8749050e6508c5 Content-Type: text/x-patch; charset=US-ASCII; name="0001-Advise-devs-to-use-server_version_num.patch" Content-Disposition: attachment; filename="0001-Advise-devs-to-use-server_version_num.patch" Content-Transfer-Encoding: base64 X-Attachment-Id: f_i5t5pgw30 RnJvbSBkYjhiODJjNTRlNDkyMzEyYzNkYzZkOTA4MTc5MDc1MzM4OTYxYWRm IE1vbiBTZXAgMTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBDcmFpZyBSaW5nZXIg PGNyYWlnQDJuZHF1YWRyYW50LmNvbT4KRGF0ZTogRnJpLCA2IEZlYiAyMDE1 IDE2OjQ5OjUzICsxMTAwClN1YmplY3Q6IFtQQVRDSF0gQWR2aXNlIGRldnMg dG8gdXNlIHNlcnZlcl92ZXJzaW9uX251bQoKLS0tCiBkb2Mvc3JjL3NnbWwv ZnVuYy5zZ21sIHwgOSArKysrKysrLS0KIDEgZmlsZSBjaGFuZ2VkLCA3IGlu c2VydGlvbnMoKyksIDIgZGVsZXRpb25zKC0pCgpkaWZmIC0tZ2l0IGEvZG9j L3NyYy9zZ21sL2Z1bmMuc2dtbCBiL2RvYy9zcmMvc2dtbC9mdW5jLnNnbWwK aW5kZXggNmQ0ZjMzMS4uMGQ3NmY5ZiAxMDA2NDQKLS0tIGEvZG9jL3NyYy9z Z21sL2Z1bmMuc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvZnVuYy5zZ21sCkBA IC0xNDQ0OSw3ICsxNDQ0OSw3IEBAIFNFTEVDVCAqIEZST00gcGdfbHNfZGly KCcuJykgV0lUSCBPUkRJTkFMSVRZIEFTIHQobHMsbik7CiAgICAgICA8cm93 PgogICAgICAgIDxlbnRyeT48bGl0ZXJhbD48ZnVuY3Rpb24+dmVyc2lvbigp PC9mdW5jdGlvbj48L2xpdGVyYWw+PC9lbnRyeT4KICAgICAgICA8ZW50cnk+ PHR5cGU+dGV4dDwvdHlwZT48L2VudHJ5PgotICAgICAgIDxlbnRyeT48cHJv ZHVjdG5hbWU+UG9zdGdyZVNRTDwvPiB2ZXJzaW9uIGluZm9ybWF0aW9uPC9l bnRyeT4KKyAgICAgICA8ZW50cnk+PHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8 Lz4gdmVyc2lvbiBpbmZvcm1hdGlvbi4gU2VlIGFsc28gPHhyZWYgbGlua2Vu ZD0iZ3VjLXNlcnZlci12ZXJzaW9uLW51bSI+IGZvciBhIG1hY2hpbmUtcmVh ZGFibGUgdmVyc2lvbi48L2VudHJ5PgogICAgICAgPC9yb3c+CiAgICAgIDwv dGJvZHk+CiAgICAgPC90Z3JvdXA+CkBAIC0xNDYzNiw3ICsxNDYzNiwxMiBA QCBTRVQgc2VhcmNoX3BhdGggVE8gPHJlcGxhY2VhYmxlPnNjaGVtYTwvPiA8 b3B0aW9uYWw+LCA8cmVwbGFjZWFibGU+c2NoZW1hPC8+LCAuLgogCiAgICA8 cGFyYT4KICAgICA8ZnVuY3Rpb24+dmVyc2lvbjwvZnVuY3Rpb24+IHJldHVy bnMgYSBzdHJpbmcgZGVzY3JpYmluZyB0aGUKLSAgICA8cHJvZHVjdG5hbWU+ UG9zdGdyZVNRTDwvcHJvZHVjdG5hbWU+IHNlcnZlcidzIHZlcnNpb24uCisg ICAgPHByb2R1Y3RuYW1lPlBvc3RncmVTUUw8L3Byb2R1Y3RuYW1lPiBzZXJ2 ZXIncyB2ZXJzaW9uLiBZb3UgY2FuIGFsc28KKyAgICBnZXQgdGhpcyBpbmZv cm1hdGlvbiBmcm9tIDx4cmVmIGxpbmtlbmQ9Imd1Yy1zZXJ2ZXItdmVyc2lv biI+IG9yCisgICAgZm9yIGEgbWFjaGluZS1yZWFkYWJsZSB2ZXJzaW9uLCA8 eHJlZiBsaW5rZW5kPSJndWMtc2VydmVyLXZlcnNpb24tbnVtIj4uCisgICAg U29mdHdhcmUgZGV2ZWxvcGVycyBzaG91bGQgdXNlIDxsaXRlcmFsPnNlcnZl cl92ZXJzaW9uX251bTwvbGl0ZXJhbD4KKyAgICAoYXZhaWxhYmxlIHNpbmNl IDguMikgb3IgPHhyZWYgbGlua2VuZD0ibGlicHEtcHFzZXJ2ZXJ2ZXJzaW9u Ij4gaW5zdGVhZAorICAgIG9mIHBhcnNpbmcgdGhlIHRleHQgdmVyc2lvbi4K ICAgIDwvcGFyYT4KIAogICA8aW5kZXh0ZXJtPgotLSAKMi4xLjAKCg== --001a113ceca02b8749050e6508c5 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs --001a113ceca02b8749050e6508c5--