Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVWn1-0001v0-Hk for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 11:30:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oVWn0-00058n-CU for pgsql-hackers@arkaria.postgresql.org; Tue, 06 Sep 2022 11:30:46 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVWn0-00058e-3A for pgsql-hackers@lists.postgresql.org; Tue, 06 Sep 2022 11:30:46 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oVWmx-0004YD-AK for pgsql-hackers@lists.postgresql.org; Tue, 06 Sep 2022 11:30:45 +0000 Received: from msg.df7cb.de (unknown [IPv6:2003:5b:203b:100:7627:eaff:fe52:8e03]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature ECDSA (P-384) server-digest SHA384) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 4MMNVV2DcZz3F37 for ; Tue, 6 Sep 2022 13:30:42 +0200 (CEST) Date: Tue, 6 Sep 2022 13:30:41 +0200 From: Christoph Berg To: PostgreSQL Hackers Subject: (doc patch) psql version compatibility Message-ID: Mail-Followup-To: Christoph Berg , PostgreSQL Hackers MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="DKyT6wCNIEsTdo1B" Content-Disposition: inline List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --DKyT6wCNIEsTdo1B Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Hi, I didn't understand the current wording of the NOTES section in psql(1) on which major versions psql is compatible with, so here's a patch to make that more explicit. Christoph --DKyT6wCNIEsTdo1B Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-psql-ref.sgml-Be-more-specific-about-major-versions-.patch" From 89f947c215c679004e1f3fbf88751fe527e16f91 Mon Sep 17 00:00:00 2001 From: Christoph Berg Date: Tue, 6 Sep 2022 13:21:48 +0200 Subject: [PATCH] psql-ref.sgml: Be more specific about major versions support The old wording only mentioned \d, but in practise even `psql -l` would fail for pre-9.2 servers, so be more clear about the version range. --- doc/src/sgml/ref/psql-ref.sgml | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 186f8c506a..09e3da7c24 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -4946,20 +4946,19 @@ PSQL_EDITOR_LINENUMBER_ARG='--line ' - psql works best with servers of the same - or an older major version. Backslash commands are particularly likely + psql works with servers of the same + or an older major version, back to 9.2. Backslash commands are particularly likely to fail if the server is of a newer version than psql - itself. However, backslash commands of the \d family should - work with servers of versions back to 9.2, though not necessarily with - servers newer than psql itself. The general + itself, or older than 9.2. The general functionality of running SQL commands and displaying query results - should also work with servers of a newer major version, but this cannot + should also work with servers of a other major versions, but this cannot be guaranteed in all cases. If you want to use psql to connect to several servers of different major versions, it is recommended that you use the - newest version of psql. Alternatively, you + newest version of psql. (To connect to pre-9.2 servers, + use psql 14 or earlier.) Alternatively, you can keep around a copy of psql from each major version and be sure to use the version that matches the respective server. But in practice, this additional complication should -- 2.35.1 --DKyT6wCNIEsTdo1B--