banner vs version
[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 or terminate 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
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/
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