Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eDyn5-0004Gx-U1 for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Nov 2017 20:23:40 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1eDyn5-00032J-6H for pgsql-hackers@arkaria.postgresql.org; Sun, 12 Nov 2017 20:23:39 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eDylS-0000DT-2w for pgsql-hackers@postgresql.org; Sun, 12 Nov 2017 20:21:58 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eDylO-0005Zj-O1 for pgsql-hackers@postgresql.org; Sun, 12 Nov 2017 20:21:57 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id vACKLjCO023435; Sun, 12 Nov 2017 15:21:45 -0500 From: Tom Lane To: Pavel Stehule cc: Fabien COELHO , Robert Haas , Corey Huinker , Daniel Verite , PostgreSQL Developers Subject: Re: Variable substitution in psql backtick expansion In-reply-to: References: <3926.1491159242@sss.pgh.pa.us> <13303.1503698976@sss.pgh.pa.us> <14596.1503701034@sss.pgh.pa.us> <20786.1503760136@sss.pgh.pa.us> <24850.1503766425@sss.pgh.pa.us> <4959.1503774468@sss.pgh.pa.us> <2947.1504542679@sss.pgh.pa.us> <14258.1504557328@sss.pgh.pa.us> Comments: In-reply-to Pavel Stehule message dated "Fri, 10 Nov 2017 15:49:28 +0100" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <23433.1510518105.1@sss.pgh.pa.us> Date: Sun, 12 Nov 2017 15:21:45 -0500 Message-ID: <23434.1510518105@sss.pgh.pa.us> List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org Pavel Stehule writes: > [ psql-server-version-2.patch ] I think this patch should be rejected. It adds no new functionality; you can get the string in question with "select version()". Moreover, you've been able to do that for lo these many years. Any application that tried to depend on this new way of getting the string would fail when working with an older server or older psql. That does not seem like a good property for a version check. Also, because the string isn't especially machine-friendly, it's not very clear to me what the use-case is for an application to use it at all, rather than the other version formats we already provide. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers