Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.

From: Fabien COELHO <coelho(at)cri(dot)ensmp(dot)fr>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Robert Haas <robertmhaas(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.
Date: 2017-09-05 18:58:37
Message-ID: alpine.DEB.2.20.1709052051590.17848@lancre
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers


Hello Simon,

> Does raise the further question of how psql behaves when we connect to
> a pre-10 server, so we have SERVER_VERSION_NUM but yet it is not set.
> How does this
> \if SERVER_VERSION_NUM < x

The if does not have expressions (yet), it just handles TRUE/ON/1 and
FALSE/0/OFF.

> Do we need some macro or suggested special handling?

If "SERVER_VERSION_NUM" is available in 10, then:

-- exit if version < 10 (\if is ignored and \q is executed)
\if false \echo "prior 10" \q \endif

-- then test version through a server side expression, will work
SELECT :SERVER_VERSION_NUM < 110000 AS prior_11 \gset
\if :prior_11
-- version 10
\else
-- version 11 or more
\endif

--
Fabien.

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Fabien COELHO 2017-09-05 19:01:25 Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.
Previous Message Tom Lane 2017-09-05 18:23:03 Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2017-09-05 19:01:25 Re: [COMMITTERS] pgsql: Add psql variables showing server version and psql version.
Previous Message Andres Freund 2017-09-05 18:52:30 Re: JIT compiling expressions/deform + inlining prototype v2.0