Re: banner vs version

On Wed, 2004-09-15 at 09:15, G u i d o B a r o s i o wrote:
> [postgres(at)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