Re: Version number in psql banner
Jim C. Nasby <jnasby@pervasive.com>
From: "Jim C. Nasby" <jnasby@pervasive.com>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Darcy Buskermolen <darcy@wavefire.com>, pgsql-hackers@postgresql.org, Peter Eisentraut <peter_e@gmx.net>
Date: 2005-09-02T04:34:37Z
Lists: pgsql-hackers
On Thu, Sep 01, 2005 at 11:18:25PM +0100, Simon Riggs wrote: > On Thu, 2005-09-01 at 14:53 -0400, Tom Lane wrote: > > Darcy Buskermolen <darcy@wavefire.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. > > Thats the way Oracle sql*plus has worked for years, so its fairly > acceptable to a great many people without too many questions. > > > The other question is what counts as "different" --- do we want to > > complain like this if the minor versions are different? > > Which is much harder to define and could itself have a bug in it, so I > prefer the verbose message.... its much better to know for certain every > time. I was going to mention that we should report server version info any time we connect to a different server, though I guess \connect only allows you to connect to a different database on the same server. As a side note, there's a typo in \?: \c[onnect] [DBNAME|- [USER]] Note the | where there should be a ]. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com 512-569-9461