Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgsql: Conditionally output the server version number in psql if it

pgsql: Conditionally output the server version number in psql if it

From
momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Log Message:
-----------
Conditionally output the server version number in psql if it doesn't
exactly match the client version number, and warn about major version
mismatches.

Modified Files:
--------------
    pgsql/src/bin/psql:
        startup.c (r1.120 -> r1.121)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/startup.c.diff?r1=1.120&r2=1.121)

Re: pgsql: Conditionally output the server version number in psql if it

From
Michael Fuhr
Date:
On Mon, Sep 05, 2005 at 10:59:08AM -0300, Bruce Momjian wrote:
> Conditionally output the server version number in psql if it doesn't
> exactly match the client version number, and warn about major version
> mismatches.

Any reason not to print a "server version" string that looks like
the actual version?  Here's what I get connecting to various servers,
along with the integer that PQserverVersion() returns:

8.0.3   server version 8.03  (80003)
7.4.8   server version 7.48  (70408)
7.3.10  server version 7.3   (70310)
7.2.8   server version 7.28  (70208)

Note in particular the missing minor version when connecting to
7.3.10.  Why the inconsistency, and why no dot between major and
minor?  Or did I miss that discussion?

--
Michael Fuhr

Re: pgsql: Conditionally output the server version number in psql if it

From
Tom Lane
Date:
Michael Fuhr <mike@fuhr.org> writes:
> Note in particular the missing minor version when connecting to
> 7.3.10.  Why the inconsistency, and why no dot between major and
> minor?  Or did I miss that discussion?

I agree, this is pretty bogus.  Cleaned up ...

            regards, tom lane