Re: versions

"Al Bean" <albean84@hotmail.com> writes:

> mytestdb-# select current_timestamp;
> ERROR:  parser: parse error at or near "select"

That command by itself should be fine.  I suspect you had something left
over in psql's command buffer from an incomplete previous command
(forgot the semicolon maybe?)

> mytestdb=# create function test1() returns integer as 'begin return 1; end;'
> language 'plpgsql';
> ERROR:  Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.

You didn't install plpgsql (see createlang script).

            regards, tom lane