From: Tom Lane <tgl@sss.pgh.pa.us>
To: Euler Taveira <euler@timbira.com.br>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: psql show URL with help
Date: Fri, 22 Feb 2019 09:55:27 -0500
Message-ID: <25863.1550847327@sss.pgh.pa.us> (raw)
In-Reply-To: <CAHE3wghfmH9rOAQNjJLck_rU3E7UTscBYUDtcbmWzvNDWQgj1g@mail.gmail.com>
References: <40179bd0-fa7d-4108-1991-a20ae9ad5667@2ndquadrant.com>
<CAHE3wghfmH9rOAQNjJLck_rU3E7UTscBYUDtcbmWzvNDWQgj1g@mail.gmail.com>
Euler Taveira <euler@timbira.com.br> writes:
> Em qui, 21 de fev de 2019 às 14:28, Peter Eisentraut
> <peter.eisentraut@2ndquadrant.com> escreveu:
>> URL: https://www.postgresql.org/docs/12/sql-analyze.html> What happen if I connect to an old server? Did it print URL according
> to psql version or server version? psql prints help about its version
> and if user wants details about a command, clicks in the URL but what
> is shown is 12 docs but user is accessing a 9.4 server.
The syntax summary that psql is showing is for its own version, and
I'd say the URL must be too. You can't even be sure that a corresponding
URL would exist in another version, so blindly inserting the server's
major version into a URL string that psql has doesn't seem like a bright
idea.
(I'm assuming that the implementation Peter has in mind is that these
URLs would just be part of the prefab help text that psql has for
various commands. If we somehow involved the server in it, then
maybe things could be different; but I doubt that's possible without
a protocol change, which it's probably not worth.)
In the end, if you are using a server version that's different from
your psql version, there are lots of ways things could go wrong.
I think it's up to the user to take psql's help with a grain of salt
in such cases.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, euler@timbira.com.br, peter.eisentraut@2ndquadrant.com
Subject: Re: psql show URL with help
In-Reply-To: <25863.1550847327@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox