Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gwxRH-0003k5-ON for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Feb 2019 23:07:35 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gwxRE-0008Vs-UL for pgsql-hackers@arkaria.postgresql.org; Thu, 21 Feb 2019 23:07:32 +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_SHA1:256) (Exim 4.89) (envelope-from ) id 1gwxRE-0008Vk-Mj for pgsql-hackers@lists.postgresql.org; Thu, 21 Feb 2019 23:07:32 +0000 Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gwxR6-0004G3-RC for pgsql-hackers@postgresql.org; Thu, 21 Feb 2019 23:07:31 +0000 Received: by fetter.org (Postfix, from userid 1001) id 0ED5F40294; Fri, 22 Feb 2019 00:07:23 +0100 (CET) Date: Fri, 22 Feb 2019 00:07:22 +0100 From: David Fetter To: Peter Eisentraut Cc: pgsql-hackers Subject: Re: psql show URL with help Message-ID: <20190221230722.GG10435@fetter.org> References: <40179bd0-fa7d-4108-1991-a20ae9ad5667@2ndquadrant.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <40179bd0-fa7d-4108-1991-a20ae9ad5667@2ndquadrant.com> User-Agent: Mutt/1.9.4 (2018-02-28) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Feb 21, 2019 at 06:28:09PM +0100, Peter Eisentraut wrote: > As mentioned on > > https://www.cybertec-postgresql.com/en/looking-at-mysql-8-with-postgresql-goggles-on/ > > how about this: > > => \h analyze > Command: ANALYZE > Description: collect statistics about a database > Syntax: > ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ] > ANALYZE [ VERBOSE ] [ table_and_columns [, ...] ] > > where option can be one of: > > VERBOSE > SKIP_LOCKED > > and table_and_columns is: > > table_name [ ( column_name [, ...] ) ] > > URL: https://www.postgresql.org/docs/12/sql-analyze.html > ^^^^ > > (Won't actually work because the web site isn't serving "12" URLs yet, > but that's something that could probably be sorted out.) Since there's no longer any mystery as to what the upcoming major version of PostgreSQL will be, it should be pretty straightforward to redirect integers > max(released version) to the devel docs. This could cause some confusion because we branch long (feature- and bug-wise) before we do the release, and a checkout from immediately after branching will be *very* different from one just before the release. The way I've come up with to clear this up is *way* too expensive: lazily create doc builds for each SHA1 requested. Pointing people at the latest devel docs is less confusing than pointing them at nothing or at the previous version, those being, as far as I can tell, the viable alternatives. Best, David. -- David Fetter http://fetter.org/ Phone: +1 415 235 3778 Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate