[HACKERS] Version number in psql banner
A release or two ago we added the version number to the psql welcome banner. I noticed that quite a few people interpret that as the server version. Somehow, the explicit display of the version numbers leads them to make inferences that they would otherwise not bother about. Has anyone else experienced that? I suppose there was a reason we added the version number there, but I can't recall it. Could we make that more clear? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Version number in psql banner
On Thu, Sep 01, 2005 at 05:30:34PM +0200, Peter Eisentraut wrote: A release or two ago we added the version number to the psql welcome banner. I noticed that quite a few people interpret that as the server version. Somehow, the explicit display of the version numbers leads them to make inferences that they would otherwise not bother about. Has anyone else experienced that? I suppose there was a reason we added the version number there, but I can't recall it. Could we make that more clear? I think the rationale for not adding the server version is that you could tell people to do select version(), so it would be unneeded verbosity, but certainly a lot of people doesn't even know they can do that. I think by far the easiest and clearest is to show both psql's version and the server version. Not the whole version() string, as that is too verbose -- just the version number. -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com Cuando miro a alguien, m?s me atrae c?mo cambia que qui?n es (J. Binoche) ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Version number in psql banner
Peter, A release or two ago we added the version number to the psql welcome banner. I noticed that quite a few people interpret that as the server version. Somehow, the explicit display of the version numbers leads them to make inferences that they would otherwise not bother about. Has anyone else experienced that? I suppose there was a reason we added the version number there, but I can't recall it. Could we make that more clear? Well, Bruce just drafted a patch to warn when the PSQL version and the server version don't match up, because of PSQL incompatibilities. However, that won't help for minor versions. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Version number in psql banner
On Thursday 01 September 2005 08:30, Peter Eisentraut wrote: A release or two ago we added the version number to the psql welcome banner. I noticed that quite a few people interpret that as the server version. Somehow, the explicit display of the version numbers leads them to make inferences that they would otherwise not bother about. Has anyone else experienced that? I suppose there was a reason we added the version number there, but I can't recall it. Could we make that more clear? 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 -- Darcy Buskermolen Wavefire Technologies Corp. http://www.wavefire.com ph: 250.717.0200 fx: 250.763.1759 ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Version number in psql banner
Darcy Buskermolen [EMAIL PROTECTED] 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? regards, tom lane ---(end of broadcast)--- TIP 6: explain analyze is your friend
Re: [HACKERS] Version number in psql banner
On Thu, 2005-09-01 at 14:53 -0400, Tom Lane wrote: Darcy Buskermolen [EMAIL PROTECTED] 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. Best Regards, Simon Riggs ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [HACKERS] Version number in psql banner
On Thu, 1 Sep 2005, Darcy Buskermolen wrote: 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 I second this, I think that something like psl client version 8.03 connected to server db01 running PostgreSQL version 8.1 would be real swell. Cheers, Aly. -- Aly S.P Dharshi [EMAIL PROTECTED] A good speech is like a good dress that's short enough to be interesting and long enough to cover the subject ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
Re: [HACKERS] Version number in psql banner
On Thu, Sep 01, 2005 at 11:34:37PM -0500, Jim C. Nasby wrote: As a side note, there's a typo in \?: \c[onnect] [DBNAME|- [USER]] Note the | where there should be a ]. Eh? Looks right to me; the | indicates an alternate, i.e., that you can use either DBNAME or -. I often use - to connect to the same database as a different user. test= \c - postgres You are now connected as new user postgres. test=# -- Michael Fuhr ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
