Re: psql show URL with help

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Euler Taveira <euler(at)timbira(dot)com(dot)br>
Cc: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: psql show URL with help
Date: 2019-02-22 14:55:27
Message-ID: 25863.1550847327@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Euler Taveira <euler(at)timbira(dot)com(dot)br> writes:
> Em qui, 21 de fev de 2019 às 14:28, Peter Eisentraut
> <peter(dot)eisentraut(at)2ndquadrant(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2019-02-22 14:57:33 Re: FOP warnings about id attributes in title tags
Previous Message Julien Rouhaud 2019-02-22 14:54:17 Re: Checksum errors in pg_stat_database