Postgres Pro
Downloads
Home   >   mailing lists

Thread: banner vs version

banner vs version

From
G u i d o B a r o s i o
Date:
[postgres@prdpwgb0208 local]$ psql template1
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms      \h for help with SQL commands      \? for help with psql commands      \g
orterminate with semicolon to execute query      \q to quit
 

template1=# select version();                          version
-------------------------------------------------------------PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC
2.96
(1 row)

template1=#


Is this ok? Banner version, 8 beta2, version() returns 7.4.2.

Regards

Re: banner vs version

From
Peter Eisentraut
Date:
G u i d o B a r o s i o wrote:
> Is this ok? Banner version, 8 beta2, version() returns 7.4.2.

The banner shows the psql (client) version, version() shows the server 
version.


-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/

Re: banner vs version

From
James William Pye
Date:
On Wed, 2004-09-15 at 09:15, G u i d o B a r o s i o wrote:
> [postgres@prdpwgb0208 local]$ psql template1
> Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
> template1=# select version();
>                            version
> -------------------------------------------------------------
>  PostgreSQL 7.4.2 on i686-pc-linux-gnu, compiled by GCC 2.96
> (1 row)
>
> Is this ok? Banner version, 8 beta2, version() returns 7.4.2.

I think this explains the problem that you e-mailed in earlier.
You probably tried to install a 8.0beta2 plpgsql into a 7.4.2 backend.

AFAIK, this is fine, 8.0 psql clients should be able to connect to 7.4
backends (;

--
Regards,       James William Pye