Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Version number in psql banner

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Darcy Buskermolen <darcy(at)wavefire(dot)com>,Peter Eisentraut <peter_e(at)gmx(dot)net>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Version number in psql banner
Date: 2005-09-03 00:39:52
Message-ID: 200509030039.j830dqd16598@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> Darcy Buskermolen <darcy(at)wavefire(dot)com> writes:
> > Yes I've seen the same frustration from users,  I think the banner should say
> > something along the lines of "psql client version foo connected to server bar
> > version sfoo" 
> 
> That seems overly verbose, particularly in the normal case where the
> versions are indeed the same.  I could live with seeing a display like
> that when the versions are different.
> 
> The other question is what counts as "different" --- do we want to
> complain like this if the minor versions are different?

I updated the patch.  This gives psql three output displays on startup:

full match:

	Welcome to psql 8.1beta1, the PostgreSQL interactive terminal.

major match:

	Welcome to psql, the PostgreSQL interactive terminal.
	psql version 8.19, server version 8.1

and non-major match:
	
	WARNING:  You are connected to a server with major version 8.1,
	but your psql client is major version 8.2.  Informational backslash
	commands, like \d, might not work properly.
	
	Welcome to psql, the PostgreSQL interactive terminal.
	psql version 8.29, server version 8.1

Patch attached.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-09-03 00:41:48
Subject: Re: Remove xmin and cmin from frozen tuples
Previous:From: Manfred KoizarDate: 2005-09-02 23:25:06
Subject: Re: Remove xmin and cmin from frozen tuples

pgsql-patches by date

Next:From: Stephan SzaboDate: 2005-09-03 05:16:07
Subject: Re: [PATCHES] Work-in-progress referential action trigger timing
Previous:From: Andrew DunstanDate: 2005-09-02 22:44:07
Subject: Re: Note that spaces between QUOTE and DELIMITER are included

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group